Filter Production Dates on a Visual based on Data

[frittle]

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 tables, one called "Puffer Vergleich" which is my main data table und gives me the buffer fill levels, then there is the "Soll Werte" Table, that tells me whether there was production or not, see the data of production days below:

If the "Productiondays" Column says "No Production", I want the corresponding Date ("Datum Sollwerte") to be excluded from my Donut visual as you can see in my dashboard below: 

It's important to mention that the date is selected from a "Main Dates Table", So far I haven't figured out a way to filter since the "production days" column somehow doesn't connect with the date (I have already done the connections of the production date with the main date table). If anyone has any Ideas on how to filter the non production days (especially in the Donut Chart) any help is appreciated. 

Best Regards

[frittle]

Hi @rohit_singh ,

Many Thanks for your quick reply, This works!

Best regards,
Leo

[rohit_singh · Accepted solution]

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! 😊