Forum Discussion

amaniramahi's avatar
amaniramahi
Helper V
7 years ago
Solved

Calculated measure in column chart

Hi,   I have a table contains Cost and sales for many models, I managed to create a measure to calculate the profit margin (difference between them divided by the sales). now i want to create a vi...
Need Help
  • MauriceMecowe's avatar
    MauriceMecowe
    7 years ago

    Hi amaniramahi 

     

    In the modeling tab from Power BI Desktop you will find the formatting option in the 'Formatting' section for percentages.

     

    If your measure is persisted in a ssas model, click on the measure field. The properties pane should show on the bottom right. Here you can pick the option percentage and enter the correct amount of decimals under the option 'Decimal Places'.

     

    If this post helps, then please consider Accept it as the solution.

MauriceMecowe's avatar
MauriceMecowe
Resolver II
7 years ago

Hi amaniramahi 

 

In the modeling tab from Power BI Desktop you will find the formatting option in the 'Formatting' section for percentages.

 

If your measure is persisted in a ssas model, click on the measure field. The properties pane should show on the bottom right. Here you can pick the option percentage and enter the correct amount of decimals under the option 'Decimal Places'.

 

If this post helps, then please consider Accept it as the solution.