Hide Title = IF(MAX('Table'[Column1]) = "View 1", "", "Sum of User Count by Department"), this worked for me. This expression uses the MAX function to get the maximum value of 'Column1' within the current filter context. If the maximum value is equal to "View 1", it returns an empty string "", which effectively hides the title. Otherwise, it returns the specified title "Sum of User Count by Department".
Great video. Thank you. However, when I add the hide visual as a filter for one of my graph, I am not getting the drop down in the filter. Its greyed out. It's showing only " is less than and no other option". Can you please guide me ?
Hello, thanks for your video! I did and it worked for the bar charts but, I would like to show/hide a measurer graph (like a clock) but when I take the measure created to the filters it does not allow me to chose "equal to 0", it does not let me display those options. i hope you can help me, thanks!!
It's not working on other visual. I tried applying the concept on a table and card visual but the visual is not hiding. Only the title of the visual. Do you have other solution to hide a table or a card visual? My requirement is I have 2 visual that is overlapped together. The other visual should be hidden and the other should be visible based on slicer selection
I have same scenario to have 2 tables overlapped .. I was able to hide table , But was not able to hide the table header /title..im unable to do so..is that possible?
Hi Srnivas Garu , It is not working at table visual , the below my requirement when user selects the filter or slicer , If no data is there ,the card has to show "No Items" along with no visual should displayed(should hide the all visuals ) while no data in any visual .. Could you please make the video on it as it is bit urgent
Hi sir, thanks for sharing. However, it doesn't work on map visual; data is gone but the map is still there. Is there any alternative? Please help and advise, thank you.
It’s very nice of you to consider helping, however I solved this problem later using bookmark, not ideal, but it’s working. Thank you again for creating all these helpful videos!
I need to do the same requirement but based on date slicer and i need to hide only one bar(so can say particular product) in a bar chart.. So can i know how can i achieve this?
What if i want to hide any chart if we change slicer value not on just two category India & US, and by making button to show chart like base on my requirement, is this case is possible?
@@srinivaspujari i tired that but isn’t working, coz i have more than 100 countries that will male it difficult toh hide for every change in country selected
thanks alot, one more day survived at workplace.
Hide Title = IF(MAX('Table'[Column1]) = "View 1", "", "Sum of User Count by Department"), this worked for me. This expression uses the MAX function to get the maximum value of 'Column1' within the current filter context. If the maximum value is equal to "View 1", it returns an empty string "", which effectively hides the title. Otherwise, it returns the specified title "Sum of User Count by Department".
Nice, thanks for sharing your knowledge 👍
The same scenario asked me in an interview... thank you for explaining the solution.
Interview calls is there?
Thank you for sharing
Hi Srinivas,
I was asked the same scenario in one of my interview. thank you!
Great. ..thanks
Very good scenario 👏
Thank you
Great video. Thank you. However, when I add the hide visual as a filter for one of my graph, I am not getting the drop down in the filter. Its greyed out. It's showing only " is less than and no other option". Can you please guide me ?
Thank u so much sir
Hello,
Thank you sharing this. It is working well for a KPI visual but not with a Gauge chart. Any thoughts on that?
Thank you
I will check and create video on that...when I have free time... thanks for your comment
I will check and create video on that...when I have free time... thanks for your comment
Hello, thanks for your video! I did and it worked for the bar charts but,
I would like to show/hide a measurer graph (like a clock) but when I take the measure created to the filters it does not allow me to chose "equal to 0", it does not let me display those options. i hope you can help me, thanks!!
Need to look into it....I will check on that
Based on slicer selection need show the button please make video on this
It's not working on other visual. I tried applying the concept on a table and card visual but the visual is not hiding. Only the title of the visual. Do you have other solution to hide a table or a card visual? My requirement is I have 2 visual that is overlapped together. The other visual should be hidden and the other should be visible based on slicer selection
Ok.. I will create video on this
I have same scenario to have 2 tables overlapped ..
I was able to hide table ,
But was not able to hide the table header /title..im unable to do so..is that possible?
Hi Srnivas Garu , It is not working at table visual , the below my requirement
when user selects the filter or slicer , If no data is there ,the card has to show "No Items" along with no visual should displayed(should hide the all visuals ) while no data in any visual .. Could you please make the video on it as it is bit urgent
Need to check
can you do this but use a text search filter instead of slicer selection?
If you start end to end then it will good.🤗
End to end means... That is one scenario right... Can you elaborate.. I will do that...
Ok you mean course??
@@srinivaspujari end to end means from white canvas to end
Hi sir, thanks for sharing. However, it doesn't work on map visual; data is gone but the map is still there. Is there any alternative? Please help and advise, thank you.
I will check and create video on that...when I have free time... thanks for your comment
It’s very nice of you to consider helping, however I solved this problem later using bookmark, not ideal, but it’s working. Thank you again for creating all these helpful videos!
Can I hide a button/shape based on the value I choose from a dropdown ?
I need to do the same requirement but based on date slicer and i need to hide only one bar(so can say particular product) in a bar chart.. So can i know how can i achieve this?
What if i want to hide any chart if we change slicer value not on just two category India & US, and by making button to show chart like base on my requirement, is this case is possible?
Yes.... Buttons easy... You can use bookmarks
@@srinivaspujari i tired that but isn’t working, coz i have more than 100 countries that will male it difficult toh hide for every change in country selected
I’m trying to hide or show an image based on a value in a table. How would I do that?
Sir same measure i am using for table chart but table header is not hiding sir
Need to apply the same measure for the header as well
@@srinivaspujari Sir, should copy paste in quotes the column names?
So If it is bar chart how do you hide x-title and y- title?
Yes
Sir how to get into AUTOMOBILE AND OIL&GAS DOMAIN?
Not sure...
sir please give the solution of how to hide a buttons instead of visual based on slicer selection
Try with bookmark
How the title hidden while choosing one filter, but due to the measure, for one selection it should show the title
Can any one help how to hide matrix table values when there is noselection on slicer
Its not hiding the visuals ,it's hiding the country names.can you give clarity on it.
Can you try once again
Okay sir
it does not work in 2023
Title is not hiding and I don't know why
Write measure for title as well