Forum Discussion

Cherry04's avatar
Cherry04
Frequent Visitor
1 year ago
Solved

Percentage visualization

Hi all, Please help to advice my below case. thank you! I have a measure:  varTarvsAct = DIVIDE(SUM('Act'[Actual Cost]),SUM('Bud'[Target Cost]))-1 in which: Actual cost data from Jan to Apr TAr...
Need Help
v-venuppu's avatar
v-venuppu
Icon for Community Support rankCommunity Support
1 year ago

Hi Cherry04 ,

Thank you for reaching out to Microsoft Fabric Community.

Thank you Ashish_Excel for the prompt response.

I have created pbix file using sample data.Here are some steps followed to generate pbix:

1.Loaded sample data into Powerbi.

2.Created Relationships, you can check in attached pbix file.

3.Created DAX measures (Actualcost,Targetcost,%Diff).

4.Sorted MonthName by MonthNum to maintain chronological order.

You can go through the attached pbix file for your reference.

 

If this post helps, then please consider Accepting as solution to help the other members find it more quickly, don't forget to give a "Kudos" – I’d truly appreciate it! 

Thank you.