I understand that we cannot use measure value as a visual level filter.
However, I'd like to filter visualization depending on measure value.
Would you know how to implement the function below?
・setting "cat_1" & "cat_2" as slicers
・making some visualization of measure of "value"
・if a number of rows with slicer's settings is less than 2, a visualization is hidden.
When we chose "A" in cat_1 and "all" in cat_2, a visualization is not hidden. (a number of rows is 3.)
When we chose "A" in cat_1 and "A" in cat_2, a visualization is not hidden. (a number of rows is 2.)
When we chose "A" in cat_1 and "B" in cat_2, a visualization is hidden. (a number of rows is 1.)
*** In my first idea, I set measure counting numbers of rows and set it as visual level filter.
Go to Solution.
Hi @joade2co ,
Create a measure and add it to visual filter as below.
Measure = COUNTROWS(ALLSELECTED('Table'))
View solution in original post
@joade2co , You will not be able to hide visual. You create a measure and return null.
Max([cat_1]) = "All" && isfiltered([cat_2]) =False() , blank(),
Proud to be a Super User!
Check out the on demand sessions that are available now!
Check out the Winners!
Learn how Power BI works with the latest Azure data and analytics innovations at the digital event with Microsoft CEO Satya Nadella.