Forum Discussion
Customise scale in Power BI
Hi all,
I need help in customising scale in Power BI X axis. Currently the option is that w ecan select the amount in Auto, Millions, Thousands, but I need to show in Indian standards like Lakhs, Crores. I tried but couldn't achive.
Can anyone help me out?
Screenshot for reference
3 Replies
- Idrissshatila
Super User
Hello Rajath_Krishna ,
check this out https://youtu.be/a3D7oXYjM9k
If I answered your question, please mark my post as solution, Appreciate your Kudos 👍
Thank you for suggesting this video. But in this they are implementing the scale in slicer but I need that to be in axis of graph but not as slicer. Can you suggest any idea for this?
eliasayyyMemorable Member
use custom labels
create a new measure that will be your custom data labels
if you dont wnat to use M , K and bn but indian standard
just write the codes
i am not familiar with indian labels but chnage whatever you desire here
data label =
SWITCH(
TRUE(),
[Your Measure] >=10000000 , FORMAT([Your Measure] / 10000000, "0.00") & " Cr",
[Your Measure] >=100000 , FORMAT([Your Measure] / 100000, "0.00") & " L"
)
