Dynamic change of data format

[au564589]

I have a Power BI solution which includes a card that visualizes the revenue. The default format is in millions. However, is it possible to give the users the possibility to change the data format themselves to e.g. thousand, when the user only has read access on the Power BI Service? At best, the solution will include some kind of drop-down-menu where it is possible to change the format. 

Hope you guys can help me.

[v-kelly-msft]

Hi @au564589 ，

You can create 2 measures,1 showing the millions,and the other showing the thousand.Then create a slicer table to connect with the 2 measures,and the result will be changed according to the selection by the users. 

For details,you may refer to below link:

https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...

 
Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[amitchandak]

@au564589 , you can use format command can have dynamic formatting using slicer , but that might change data type to text.

similar approach as measure slicer
https://radacad.com/change-the-column-or-measure-value-in-a-power-bi-visual-by-selection-of-the-slic...
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/50...

[lkalawski]

Hi @au564589 

You can do this in two ways:

1. Personalize visuals: https://docs.microsoft.com/en-us/power-bi/consumer/end-user-personalize-visuals

You allow users to customize the visuals in the report.
2. Create an additional table that will contain the values: Million, Thousand etc. (with no relation to the other tables).
Then you create a measure that gets the value from dropdown with SELECTEDVALUE and change the values with SWITCH and FORMAT.

Similar: https://www.youtube.com/watch?v=88QSf2fB1Rg

https://community.powerbi.com/t5/Desktop/Dynamically-change-in-currency-symbol-after-currency-select...

_______________
If I helped, please accept the solution and give kudos! 😀