Forum Discussion

sabd80's avatar
sabd80
Icon for Helper IV rankHelper IV
2 years ago

Cell Formatting

Hi All, Some of the users are connecting to the Power BI semantic model from excel. They need to see specific figures in a certain order, so I created below measure: Actual Testing = SWITCH...
Need Help
lbendlin's avatar
lbendlin
Icon for Super User rankSuper User
2 years ago

All values in a column must have the same data type. 

 

What you can try instead is use separate measures (and "show values on rows")  and then export to Excel with formatting.

  • sabd80's avatar
    sabd80
    Icon for Helper IV rankHelper IV
    2 years ago

    thanks lbendlin , the measure I shared is just a sample, the list in the acutal one is much bigger, and we have to replicate it for Bugdet, and 12 month forecast, so it will make the list of measures so big and confusing