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.
Hi,
I have a column chart drill down chart that has a calculated measure that changes between # of units and % market share based on the user selection in a slicer. It works great except that the format doesn't change (i.e - I need the format to switch between % and #). I can't use FORMAT( ) as it converts it to a string and blanks out the chart. How do I make the % market share look like a % for the user (2.54% rather than .0254)?
Thank you in advance!
@Anonymous
In Power BI Desktop, it's not supported to dynamically set format for values within same measure or column. And if you use expression to format it, it will always convert values into string. So in this scenario, i suggest you separate the unit and market share into two different measures.
Regards,
Can you use some sort of IF statement and use a CONCATENATE, something like:
CONCATENATE([column]*100,"%")
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 |
---|---|
109 | |
98 | |
77 | |
66 | |
54 |
User | Count |
---|---|
144 | |
104 | |
100 | |
86 | |
64 |