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,
Trying to build a report that uses multiple parameter tables and would like to summarize all those parameter tables as a one table with the selected value for each filter selection.
Each row and column combination is a filter/slicer for users to select a number. For example, Product 1 and Next Week Default Volume; If user changes it to 6, then the table updates accordingly.
Couple follow up questions:
Can you also send me the pbix file with your example?
Yes, I am using What-if parameter for the dynamic filters (Next Week, Next Month, Next Quarter, Rest of Year) for each Product.
The filter are independent of each other and I would like to summarize all the values in the filter into one table like example below.
Hope it makes more sense on what I am trying to achieve.
Hi @jordanxie ,
I think you need to create 8 generate tables by if parameter for your 8 slicers.
Then create four measures as below.
Next Week =
VAR _SELECT1 =
SELECTEDVALUE ( 'Product 1 Next Week'[Product 1 Next Week] )
VAR _SELECT2 =
SELECTEDVALUE ( 'Product 2 Next Week'[Product 2 Next Week] )
RETURN
SWITCH (
SELECTEDVALUE ( 'Product'[Product] ),
"Product 1", _SELECT1,
"Product 2", _SELECT2
)
Next Month =
VAR _SELECT1 =
SELECTEDVALUE ( 'Product 1 Next Month'[Product 1 Next Month])
VAR _SELECT2 =
SELECTEDVALUE ( 'Product 2 Next Month'[Product 2 Next Month] )
RETURN
SWITCH (
SELECTEDVALUE ( 'Product'[Product] ),
"Product 1", _SELECT1,
"Product 2", _SELECT2
)
[Next Quarter] and [Rest of Year] are the same format as above.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
@jordanxie , Not very clear. You can use what if parameter
https://docs.microsoft.com/en-us/power-bi/transform-model/desktop-what-if
The information you have provided is not making the problem clear to me. Can you please explain with an example.
Appreciate your Kudos.
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 |
---|---|
117 | |
104 | |
77 | |
73 | |
52 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |