The ultimate Microsoft Fabric, Power BI, Azure AI, and SQL learning event! Join us in Stockholm, Sweden from September 24-27, 2024.
2-for-1 sale on June 20 only!
Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
I created a measure that calculates the value based on a selection. However, I need my measure title to be dynamic as well.
Name | Measure |
Item 1 | 1 |
Item 2 | 1 |
Item 3 | 1 |
Source Table:
Name | Selection 1 | Selection 2 | Selection 3 |
Item 1 | 1 | 2 | 3 |
Item 2 | 1 | 2 | 3 |
Item 3 | 1 | 2 | 3 |
Selection Table;
Column 1 |
Selection 1 |
Selection 2 |
Selection 3 |
Solved! Go to Solution.
Hi,
Please try to create a HeadColumn table as below:
Then try this measure:
Measure = SWITCH(SELECTEDVALUE(HeaderTable[Value]),"_Selection 1",SUM(Source[Selection 1]),"_Selection 2",SUM(Source[Selection 2]),"_Selection 3",SUM(Source[Selection 3]))
Choose [Value] as a slicer, then choose [Value] and this measure as a matrix visual.
When you select one value in slicer, the result shows:
Here is my test pbix file:
Hope this can help.
Best Regards,
Giotto Zhi
Hi,
Please try to create a HeadColumn table as below:
Then try this measure:
Measure = SWITCH(SELECTEDVALUE(HeaderTable[Value]),"_Selection 1",SUM(Source[Selection 1]),"_Selection 2",SUM(Source[Selection 2]),"_Selection 3",SUM(Source[Selection 3]))
Choose [Value] as a slicer, then choose [Value] and this measure as a matrix visual.
When you select one value in slicer, the result shows:
Here is my test pbix file:
Hope this can help.
Best Regards,
Giotto Zhi
Oh, just had an idea. You could achieve this if you used 3 buttons, 3 bookmarks and stacked visuals. So, create a visual that displays only one of your columns. Stack them on top of one another. Use the Bookmarks and Selection panes to create 3 bookmarks where you show only one of the visuals and hide the other 2. Tie your Selection buttons to these bookmarks.
It's funny too, because I actually started writing that measure that you did and stopped because I knew it wouldn't work!! 🙂
@Anonymous - Pretty sure the answer to this is still "no". 🙂
But maybe someone has a nifty way around it, I just can't think of a way.
Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.
Check out the June 2024 Power BI update to learn about new features.
User | Count |
---|---|
99 | |
90 | |
82 | |
64 | |
58 |
User | Count |
---|---|
244 | |
128 | |
118 | |
79 | |
78 |