Forum Discussion

frittle's avatar
frittle
Helper II
4 years ago
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 ...
Need Help
  • rohit_singh's avatar
    rohit_singh
    4 years ago

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

rohit_singh's avatar
rohit_singh
Solution Sage
4 years ago

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