u/land_cruizer

Hi everyone,
I have three base measures in my model : Plan, Actual, and Forecast, plus a calculated Actual + Forecast (LE).
I need to allow users to toggle between two things using slicers:

1. Metric: Plan, Actual, Forecast, and Actual + Forecast.
2. Period/Agg: Weekly, Monthly, Yearly (both for the periodic value and the running total).
   The suggestion I’ve received is to go with a mix of Calculation Groups (for time intelligence) and Field Parameters (for the base measure selection). I want something which can seamlessly work on card and table/matrix visuals. Looking forward to more ideas from the pros

Hi, I'm running into an issue where my slicer from master date table is filtering out the data I need for a matrix visual, so I've opted for a disconnected table (⁠created using SELECTCOLUMNS for the required fields ⁠) for my report slicers.Is this the right way to handle this?