Display Actuals with Forecast in Matrix

[rohitk1361]

I have data like below 

What I want to do is show Forecast as a selector with only Apr Forecast and Plan as values in that selector, however in matrix i want to see 2022 - 2025, year 2025 will be dynamic based on selection. 2022 to 2024 has to be static defaulting to actuals.

[Anonymous · Accepted solution]

Hi @rohitk1361 

Thank you very much speedramps for your prompt reply.

For your question, here is the method I provided:

Here's some dummy data

“Table”

You should have a table to use as a slicer.

“Select Table”

Create a measure.

Measure = 
VAR SelectVersion = SELECTEDVALUE('Select Table'[Select Version])
VAR _Version = SELECTEDVALUE('Table'[Version])
RETURN
SWITCH(
    TRUE(),
    _Version = "Actuals" || _Version = SelectVersion, 1,
    BLANK()
)

Add this measure to "Filters" and filter it to a value of "1".

Here is the result.

Regards,

Nono Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[speedramps]

We ant to help but your decsription is a bit vague.

Please try writing it again more clearly.

Try use Power BI terminolgy and avoid creating your own jargon like "selector"

(Do you mean slicer, filter or something else?)

Please provide input data as a table rather than a screen print, so it can be quickly imported to build a solution.

Please provide example output with clear step by step descriptions and try use consistent column names on the input, output and process description.

Yiu will get a quick and better response if you decsribe your problems clearly.