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.
Add an additional measure and take advantage of Visual level filters..
Measure = IF ( [Selected Period Status] IN VALUES ( Table2[Selected Period Status] ), 1 )
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.
It’s time for another PBI Community recap!
Visit our Community Blog for articles, guides, and information created by fellow community members.
Need help with the Power BI Community? Our 'Using the Community' support articles are a great place to start.
Looking for inspiration on how to present your data? Need instructional videos? Check out our Galleries!