Check your eligibility for this 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700.
Get StartedDon'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.
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.
Solved! Go to 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.
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.
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.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Prices go up Feb. 11th.
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
User | Count |
---|---|
21 | |
15 | |
14 | |
11 | |
9 |
User | Count |
---|---|
27 | |
23 | |
12 | |
11 | |
10 |