Forum Discussion
Dynamic change of data format
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.
3 Replies
- lkalawski
Resident Rockstar
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
_______________
If I helped, please accept the solution and give kudos! 😀 - amitchandak
Super User
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-slicer-parameter-table-pattern
https://community.powerbi.com/t5/Desktop/Slicer-MTD-QTD-YTD-to-filter-dates-using-the-slicer/td-p/500115 
v-kelly-msftCommunity Support
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:
Best Regards,
KellyDid I answer your question? Mark my post as a solution!
