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.
Hello wonderful forum users!
Next on my task list is to create a report with a toggle to view metrics by a different unit. For example, imagine you have a pivot table with Resources being the rows and Week Numbers being the columns. I may want the values in the center to be billed hours, non-billed hours, total hours, or billed dollars. I'd be ok if the toggle was limited to just two (off/on) though.
In researching this it seems one method is to use bookmarks where I essentially have to make multiple copies of the table overlapping each other. However, is that really the only option available? It seems a bit overly complex for such a straight forward requirement.
Solved! Go to Solution.
Hi @Anonymous ,
To view metrics by a different unit, maybe you can create a new table including the unit, for example, thousand, million...and put this column in a silcer, create a measure like this:
Measure =
var uint = SELECTEDVALUE(test[Unit])
return
IF(
uint = "K",
DIVIDE(SELECTEDVALUE('Table'[Value]),1000) & "K",
IF(
uint = "M",
DIVIDE(SELECTEDVALUE('Table'[Value]),1000000) & "M"
)
)
This is just a sample, you can refer it depending on your specific situations.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
Hi @Anonymous ,
To view metrics by a different unit, maybe you can create a new table including the unit, for example, thousand, million...and put this column in a silcer, create a measure like this:
Measure =
var uint = SELECTEDVALUE(test[Unit])
return
IF(
uint = "K",
DIVIDE(SELECTEDVALUE('Table'[Value]),1000) & "K",
IF(
uint = "M",
DIVIDE(SELECTEDVALUE('Table'[Value]),1000000) & "M"
)
)
This is just a sample, you can refer it depending on your specific situations.
Best Regards,
Yingjie Li
If this post helps then please consider Accept it as the solution to help the other members find it more quickly.
@v-yingjl this is genius!!! A little "hacky", and honestly way more effort than it should be, but still I like the creativity of it!
@Anonymous , did not get it completely
Refer
Dynamically change chart axis in Power BI
https://www.youtube.com/watch?v=6jeSIRpjv0M
https://radacad.com/bookmarks-and-buttons-making-power-bi-charts-even-more-interactive
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 |
---|---|
113 | |
97 | |
85 | |
70 | |
61 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |