View various metrics with a Toggle on Pivot Charts? Other than bookmarks.

[Anonymous]

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.

[v-yingjl · Accepted 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.

[Anonymous]

@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!

[amitchandak]

@Anonymous , did not get it completely

Refer

https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115

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