Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi 🙂
If I want to assemble a report from two or more sets of slicers, for example:
A financial report that presents annual data (January - December) and will be something like that:
January - March – Actual Data
April - June – Forecast
July - December - Budget
How can I reach the desired outcome using multiple slicers?
i.e. there is a table called " Reporting Cycle" (1 for "Budget", 2 for "Forecast", 3 for "Actual" ect..)
and there is a table called "Months" (1, 2 ,3 and so on..)
If I'll choose "budget" on reporting cycle slicer, I will get only the budget for the entire year
And if I'll choose "forecast" or "actual" on reporting cycle slicer, I will receive the same
What I need is a combination, which means
Actual for January to March ((months between 1 and 3) and (Reporting Cycle = 3))
Forecast only for April to June ((months between 4 and 6) and (Reporting Cycle = 2))
And budget only for July-December ((months between 7 and 12) and (Reporting Cycle = 1))
Any idea ?
Solved! Go to Solution.
Hi @yossil
You may refer to this sample file and check if measure Combination2 matches your request.
Regards,
Cherie
Hi @yossil
You may refer to below measure. If it is not your case, please let me know and share your data sample.
combination = SWITCH ( SELECTEDVALUE ( Report[Reporting Cycle] ), 3, CALCULATE ( SUM ( Report[Values] ), FILTER ( 'Calendar', 'Calendar'[Months] IN { 1, 2, 3 } ) ), 2, CALCULATE ( SUM ( Report[Values] ), FILTER ( 'Calendar', 'Calendar'[Months] IN { 4, 5, 6 } ) ), 1, CALCULATE ( SUM ( Report[Values] ), FILTER ( 'Calendar', 'Calendar'[Months] IN { 7, 8, 9, 10, 11, 12 } ) ) )
Regards,
Cherie
Hi @yossil
You may refer to this sample file and check if measure Combination2 matches your request.
Regards,
Cherie
Hi and thanks for replying.
your'e proposal is actually hardcoding the combination
I want this to be dynamic as year goes.
attached screenshot, each color represent 2 slicers working combined as "AND" argument
the question is How do we make each color to interact with other color as "OR" argument
to get final result as you can see from right.
thanks.
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
112 | |
99 | |
73 | |
72 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |