Forum Discussion
How to apply/set Filter to Visual Table column specific to data
I have a column DueStatus contains data eg
Overdue
Due This Month
Due Next 90 Days
Not Due
No Review Date
On the report, I would like to display a Visual snapshot summary of the different status. perhaps the visuals are tables eg to display
Overdue tasks only, with employee name assigned to task, due date, days overdue
Due This Month tasks only, employee name assigned to taks, due date
Due Next 90 Days tasks only, employee name assigned to taks, due date
etc
On the report I added the visual Table, and filter. However I donot know how to app,y 'Filters' specific for each visual table
Is there a way to set/filter each table and a colum to a specific dataset? how can this be achieved
TIA
dd88 , Create measure on due status that make sure not null values are displayed
countrows(filter(Table, not(isblank( Table[Due This Month] )) )
Now you can use these measures in field parameters and based on selection it will change the rest of the data
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f
1 Reply
dd88 , Create measure on due status that make sure not null values are displayed
countrows(filter(Table, not(isblank( Table[Due This Month] )) )
Now you can use these measures in field parameters and based on selection it will change the rest of the data
Power BI Field Parameters — A Quick way for Dynamic Visuals: https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9afd
Power BI Field Parameters- Measure Slicer and Axis/Dimension slicer: https://youtu.be/lqF3Wa1FllE
Switch TOPN with Field Parameters: https://amitchandak.medium.com/switch-topn-with-field-parameters-299a0ae3725f