Forum Discussion

musa's avatar
musa
Frequent Visitor
8 years ago
Solved

DAX measure not working with Card visualization

Hi, I am experiencing an issue where a DAX measure:

Actual Closed- Won divided by Budgeted Closed-Won = DIVIDE( SUM('Weekly Summary'[Actual Closed- Won]), SUM('Weekly Summary'[Budgeted Closed-Won]) )

 

is not working when displayed as a 'card' visulization (big number tile), however, if I create a bar chart visualization I am getting the expected results. The calculation should = 0.86. I am wondering why the measure works when visualized as a bar chart but not as a Card type visualization.

 

Thank you, 

 

 

  • musa

    For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?

     

2 Replies

  • anandav's avatar
    anandav
    Skilled Sharer

    musa

    For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?

     

    • musa's avatar
      musa
      Frequent Visitor

      This was it, I realized that I have to select on the field in order to make formatting changes, formatting changes won't apply to the visualization directly.

       

      Thank you!