Value Formatting Based Upon Slicer Selected Measure

[Eric25]

I'm using a Slicer Table to create a custom report writer where the user selects the variables they wish to see and the matrix responds.

I accomplish this using Switch:

Value1 = SWITCH(MAX('Value1'[V1Sel]),1,[Rev $],2,[GM%],3,[NM %],4,[Spoil %],5,[Comm %],6,[Machines],7,[Cashless %],8,[Spoil $],9,[Comm $],9,[Subsidy %],10,[Fill %],11,[Depleted %],12,[Sellouts Per Visit])

The user selects from a slicer which sets the max of 'Value1'[V1Sel] which switches between various defined measures.

My problem is that these values have various formats from percentages to numbers to currency. In regular Excel, I used conditional formatting rules pointing to another table to solve for this. In power BI this isn't possible.

I used FORMAT to change the measures to display correctly but because FORMAT changes everything to text, they no longer sort properly.

Anyone have any ideas?

[v-yulgu-msft]

Hi @Eric25 ,

---

My problem is that these values have various formats from percentages to numbers to currency. 

In Power BI, measure doesn't support multiple data types in its result. Currently, there is no way to achieve such a requirement, unless using FORMAT function to convert result to Text.

Regards,

Yuliana Gu