Forum Discussion

Rajath_Krishna's avatar
Rajath_Krishna
New Member
3 years ago

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,...
Need Help
Rajath_Krishna's avatar
Rajath_Krishna
New Member
3 years ago

Hi Idrissshatila 

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?

  • eliasayyy's avatar
    eliasayyy
    Icon for Memorable Member rankMemorable Member
    3 years ago

    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"
    )