Forum Discussion

ColinRE's avatar
ColinRE
Icon for Helper I rankHelper I
3 years ago
Solved

Dynamic Format for Measures - Does not display comma?

All,

Dynamic Dax format works like a charm - mostly! Some values show 2, 4 or currency format. The only issue is the comma seperator for 1000's doesn't work. It uses the #,##0.00 format but doesn't work. Tried many other things. Is this a bug? Ideas? 

 

The visual (mostly works):

The measure: 

 

 

dynamic format DAX:

 

Table view

 

 

Need Help
  • Ritaf1983's avatar
    Ritaf1983
    3 years ago

    Hi ColinRE 
    I tested the feature on my PBIX and this is no bugs

    Check the logic of your calculations or share the PBIX with the sample if you need more assistance.
    I also link my PBIX you can download it and follow my steps: Liml to a sample file 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

2 Replies

  • Ritaf1983's avatar
    Ritaf1983
    Icon for Super User rankSuper User
    3 years ago

    Hi ColinRE 
    I tested the feature on my PBIX and this is no bugs

    Check the logic of your calculations or share the PBIX with the sample if you need more assistance.
    I also link my PBIX you can download it and follow my steps: Liml to a sample file 

    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

  • ColinRE's avatar
    ColinRE
    Icon for Helper I rankHelper I
    3 years ago

    So it looks like there was a formula issue on my side yielding unexpected results. Thanks for building a sample test and validating it works. The formula I used reads off the table.