Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Excluding some data after a certain date from dashboard

Let's say I want to exclude countries a, b, and c, after 01-01-2023 on a dashboard. so, data before that time appears for countries a, b, and c but after that time those countries show blank.

One way is to write it in the query when importing from SQL to power bi, right? but I wanted to know if there are other ways to do that because sometimes there are a lot of tables.

Please let me know if you need more info and thank you for the help!

Tips and Tricks

4 Replies

  • JirkaZ's avatar
    JirkaZ
    Icon for Solution Specialist rankSolution Specialist
    3 years ago

    You could implement this logic in a measure. The question is what would happen if the user chose a date interval say 2022-01-01 until 2024-12-31?

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      The user can only choose FY and it will show each month of that year (Matrix Chart). is there a way to do it on a filter panel?

      Also, what would the Measure be considering I have dim_time, dim_location, and the data table with the country name?

      • Anonymous's avatar
        Anonymous
        Not applicable
        3 years ago

        and if the user chooses 2022-01-01 until 2024-12-31, it has to show the data until 2023-01-01 and the rest blank.