Forum Discussion
Solved
Filter Production Dates on a Visual based on Data
Dear Power BI Community, I am doing a buffer fill analysis over time in a production setting and would like to exclude days on which there was no production automatically by filtering. I have two ...
Hi frittle ,
Please try this :
1) In the "Soll Werte" Table, please create a calculated column to indicate if there was production or not
Production_Flag = if('Soll Werte'[Productiondays] = "No Production", 0 , 1)
2) Click on your donut chart, go to filters and add column Production_Flag as a visual level filter. Select value of Production_Flag = 1. This should exclude all rows where there is no production.Kind regards,
Rohit
Please mark this answer as the solution if it resolves your issue.
Appreciate your kudos! 😊
Hi rohit_singh ,
Many Thanks for your quick reply, This works!
Best regards,
Leo