The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
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,
Solved! Go to Solution.
For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?
For the card visual, did you try entering 2 in the 'Data Label' formatting 'Value decimal places'?
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!