Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
rohitk1361
Regular Visitor

Display Actuals with Forecast in Matrix

I have data like below 

 

rohitk1361_0-1736931067942.png

 

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.

 

1 ACCEPTED SOLUTION
v-nuoc-msft
Community Support
Community Support

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”

vnuocmsft_0-1736994740709.png

 

You should have a table to use as a slicer.

 

“Select Table”

vnuocmsft_1-1736995190420.png

 

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".

 

vnuocmsft_2-1736995413650.png

 

Here is the result.

 

vnuocmsft_3-1736995458229.png

 

Regards,

Nono Chen

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

 

View solution in original post

2 REPLIES 2
v-nuoc-msft
Community Support
Community Support

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”

vnuocmsft_0-1736994740709.png

 

You should have a table to use as a slicer.

 

“Select Table”

vnuocmsft_1-1736995190420.png

 

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".

 

vnuocmsft_2-1736995413650.png

 

Here is the result.

 

vnuocmsft_3-1736995458229.png

 

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
Super User
Super User

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.

 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

Jan NL Carousel

Fabric Community Update - January 2025

Find out what's new and trending in the Fabric community.