Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
NadeemAhamed
Helper IV
Helper IV

Changing Format of Measure for currency

Dear All,

Greetings!

 

I have created measures which is automatically format is text. 

 

i want to apply comma in measures for number for all DAX.

 

is it possible to apply comma for first after 3 decimal then for all after 2 decimal. 

EX: 1. 23,000

      2. 2,12,244

      3. 23,23,445

 

2nd measures: I have created measures with switch terms to fetch the values based on slicer. but for this measures i am failing to apply format.

 

Thanks in advance. 

1 ACCEPTED SOLUTION

Your data is not in a suitable format. You need to first unpivot it.

From

lbendlin_0-1713873389447.png

to 

lbendlin_1-1713873477765.png

That will remove the need for all the measures you created.  Then you need to apply the formatting only to the plan/actual items.

lbendlin_2-1713873823096.png

I'll leave the month sorting as an exercise for you.

 

View solution in original post

3 REPLIES 3
lbendlin
Super User
Super User

Indian number format can be handled by specifying it explicitly

 

Solved: INDIAN CURRENCY VALUE FORMAT - Microsoft Fabric Community

Dear @lbendlin 

 

Thank you for your valuable time to read and reply.

 

I have gone through the above solved formate but for me its not working.

for your reference i have attached the excel and .pbix file

NadeemAhamed_1-1713765138940.png

 

I have 2 vistual. matrix and card but in both is not showing as per requirement. 

 

I hope you have the access and got my query. 

Pbix: https://toyotsu.box.com/s/590uj8gf4gs229xtmzu4popa8m447mme

Excel: https://toyotsu.box.com/s/iv40ihwk157fl7ev31x1qrtmpexhvdyh

 

Your data is not in a suitable format. You need to first unpivot it.

From

lbendlin_0-1713873389447.png

to 

lbendlin_1-1713873477765.png

That will remove the need for all the measures you created.  Then you need to apply the formatting only to the plan/actual items.

lbendlin_2-1713873823096.png

I'll leave the month sorting as an exercise for you.

 

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

Check out the May 2024 Power BI update to learn about new features.