Hi Keertika, adroll_current_page = "other"; For example, selecting a state on a map visualization highlights the column chart and filters the line chart to display only data that applies to that one state. I have 7 different filters that I need to consider. In other words, if there is a value selected in the slicer, make the colour transparent, otherwise make it white (the colour of the report background) so that it hides the matrix. However, I think because it covers the bar chart area, I am losing the mouse over tool-tip information on the bars in the chart. Its all great until I try to make the visual disappear. Using the SELECTEDVALUE function in DAX - SQLBI For example, I was using it for a detailed grid, I only wanted to show information in this grid for the barcodes selected by the user. I assume that changing the cross filter behaviour between slicer and visual will not work in this case, but I cant be sure. Lets say I have two visuals I want to hide/appear based on selections. Power BI service. Solved: Dynamic Title to show Prior Month from Selected Va The measures used are: nvm i found out. If so, you could build the Check Filtered measure to react to the Part Type. I have tried this in my report and I downloaded your sample work book as well but noticed that your sample work book has same issue what I am facing. I used that technique, and it is working, but I cannot interact with the visual where I have implemented card. No kiddingthis has been a thing in Qlikview (the old tool of choice at my company) for over a decade. You should be able to drill through on the revealed visual, providing the Card is only covering the header. Do you have any idea what might cause this? I had originally shown this as a card however I realised this was a limitation and changed it to a matrix, however I have just one measure in this under values and nothing in rows/columns will this be the reason I cant add a filter? The bolded icon is the one that is being applied. Could you please share your sample pbix file if you don't have any Confidential Information.? Can we send the visual to Back/Backward using DAX? The challenge of selectively showing report elements has plagued Power BI report developers for many years now, but there is no out of the box solution for this problem at this point in time. There is a bug I have seen in Desktop, where visuals dont update when elements on the report page change. Would HASONEVALUE do the trick? Wonderful idea and smooth execution, thank you for sharing. 1. Thanks. )) correct. It is on one of the menus visible when you select the matrix. Then matrix 1 with Hide Visual = 1, matrix 2 with Hide Visual = 2 Really stumped here. It probably needs a numerical value. Can you pls help me on below senero: mountain, road) Hide Visual = IF( , 1, 0) It doesnt have to be a matrix, it could be a pie chart, column chart, or anything that takes at least two field values to display correctly. Format Style = Field Value, and in the by option, selected the Colour measure. Thanks for the article. As per my requirement, We have 10 visuals in one page( order by : 1 slicer, 5 tree maps, 2 tables , 1 bar chart and 1 line chart) all visuals needs to be appear only based on ealer filter.i tried but its not working as i expected bcz when i press 3rd visual and ot is filtering 4 visual but 3 visual became blank. Completely cover the map with your Message card, effectively hiding the map. This show visual option does not work for card and donut chart. This worked for me. Show or Hide a Power BI Visual Based on Selection The benefit of relying on the Check Filtered solution is that the card doesnt need to cover the entire Matrix, you simply need to make the card large enough to cover the header. Thank you. Did you ever figure this out? Is your Table slicing the data by the same column as your [Check Filtered] measure? I want both visuals to appear based on a selection of either Customer[Occupation] or Territory[Group]. but by using these measures it doesnt move the mask card when i choose the select all option. The best I can come up with is covering options with bookmarks (no drop-downs obviously) and bookmarking the selection. I mean in my case it may happen some time data will come some time it will not. If someone have any clues to how I could make this work, I'd really apreciate the input. The solution to solve this problem (when trying to Show or Hide a Power BI Visual Based on Selection) involves: Create a card to work as a mask for the visual. Thanks for your apport to the community. Thank you so much for the article! One other thing I am trying to achieve is combining RLS with this functionality, does RLS filter work here? appended customer 1 and customer 2 I would also like to sign up to the newsletter to receive updates whenever a new article is posted. But the final result video above is working fine. Select the masking Card made earlier. Meanwhile, thanks for sharing a great, practical woraround. And I want that zoom in/out control in Map. https://ideas.powerbi.com/ideas/idea/?ideaid=b05ea746-910f-ec11-b76a-281878e6855d, response to Pam regarding the Gauge visual below, https://exceleratorbi.com.au/plotting-2-fields-on-the-legend-of-a-chart/, https://exceleratorbi.com.au/items-not-selected-slicer/, https://exceleratorbi.com.au/expression-based-formatting-in-dax/, https://app.powerbi.com/view?r=eyJrIjoiNzg2YWJlNTAtMDI0MC00OTVlLWE5YmEtMmJjMTY5YjIxNTU3IiwidCI6ImZmMTA1ZDRmLTAzOWYtNDQ0Zi1iZDZmLTBlZDFlMzVkYWVmNCIsImMiOjh9, https://drive.google.com/open?id=1Y3kDvtsWiI9uDiBOUbutEEdXkBi9PUsX, https://exceleratorbi.com.au/conditional-formatting-with-a-text-field-in-power-bi/. As [Check Filtered] is just looking for the specific filter to be applied, there is no requirement for that filter to be coming from a slicer.