i have a power bi data 2020 and 2021 years . i choosed clusterd bar chart and slicer like
if i choose 2020 filter i want to hide 2021 data in visuals ? any idea ? thanks in advance
Go to Solution.
Hi @THENNA_41 ,
I create some data:
Here are the steps you can follow：
1. Create measure.
2. Place Measure[Flag] in Filters, set is = 1, and Apply filter.
The slicer selects 2020 and displays the data of 2020:
The slicer selects 2021 and displays the data of 2021:
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
View solution in original post
@THENNA_41 , if the visual using month year from the same table(related table) from where year is coming then it should filter. That is the default feature. What is issue you are facing ?
i am trying to hide the unseleted month empty filds in visuals please find the attached screen shot for your reference
if i choose 2020 only selected year months only visbile in chart .
Learn how to create your own user groups today!
Click here to read more about the November 2021 Updates!
Join us, in-person, December 7–9 in Las Vegas, for the largest gathering of the Microsoft community in the world.