Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago

dynamically change format in a calculated measure

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 t...
v-sihou-msft's avatar
v-sihou-msft
Icon for Microsoft Employee rankMicrosoft Employee
10 years ago

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,