Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I have below table in BI need to add a filter of status.
the status is dynamic, for example, if the selected month's profit - same month last year is possitive, then the status is Retained+, otherwise it's Retained-, etc. I can get the dynamic status per selected period in below table. now i need to add a filter to let user select the status they want to see, I saw I could filter the status in visual level filter by typing the key words but I could not add it to the filter list. I created a table with all the status and I would like to know how to link them to the dynamic status and let them interactive.
Solved! Go to Solution.
Just set Show items when the value is 1.
Add an additional measure and take advantage of Visual level filters..
Measure = IF ( [Selected Period Status] IN VALUES ( Table2[Selected Period Status] ), 1 )
Hi Sam,
I created a Measure = IF([Selected Period Status] IN VALUES('Status List'[Selected Period Status]),1)
[Selected Period Status] is the result in the table, Status List'[Selected Period Status] is in the list I selected. I'm not sure how to link this to the visual level filter. you can see when i select Retained - it gives me the result is "1". if I select other options, it gives me 0. not sure what to do now.
Drag it to the table visual as well.
I drag the measure to the visual filter but show me this.
Just set Show items when the value is 1.
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
122 | |
101 | |
71 | |
61 |