Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

DAX Formatting inside a Measure?

Hi, I have some Measures, sales, Prices, Share in different measures, to make some of my reports more flexible would I like to have all my measures in one slicer.   So what I have done is to creat...
Need Help
  • PaulDBrown's avatar
    PaulDBrown
    4 years ago

    Format the measure as a whole number, but in the price and % values follow this pattern:

    VALUES(FilterMeasures[Measure]) = "Price/EAN", FORMAT[Price/EAN], "#,##0.00"),

     

    and

    VALUES(FilterMeasures[Measure]) = "Value%Share", FORMAT([Values MS], "#0.0%")

Anonymous's avatar
Anonymous
Not applicable
4 years ago

Many thanks PaulDBrown! This give me the format I want on all the Measure!

Now next challange is sorting, because it works perfect on Val/Vol/Uni but when sorting on Price and Share it comes in nummeric order from 1to9, I have tested a bit but cant really find a solution that the highest/lowest comes first, do you know anything about this?   

PaulDBrown's avatar
PaulDBrown
Community Champion
4 years ago

The reason that the sorting is as you see it is because FORMAT returns a text string. You might try adding the numerical value as a new measure to sort the visual by. You can then hide it by turning off the text wrap options in the formatting pane and "hiding" the column by dragging the right boundary left to conceal it.