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 ...
Tips and Tricks
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. 

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

      I think something like this could work:

      My Measure := 

SUMX('DimLocation', 
  IF('DimLocation'[Country] in ("Country 1", "Country 2"), 
  CALCULATE(SUM('FactTable'[SalesAmount]), DimDate[Date] < DATE(2023, 1, 1)), 
  SUM('FactTable'[SalesAmount])
)