Forum Discussion
Using FORMAT() with CALCULATE() in charts
So just to clarify, after clicking on your datafield, when you go into the Modeling Tab of the ribbon, the option for "Format" is greyed out? I understand that Data Type should be greyed out, but my expectation is that the formatting options should still be available to you. Is the % button also greyed out?
I note that your other field is already being formatted as a percentage. This incidates to me that the formatting has been applied to that field.
I think the numbers are represented properly without multiplying or dividing by zero. Instead all I want to do is change it from decimal to percent, while still keeping its numeric value. In the screenshot below you'll see how the yellow-ish bar (the problem) is formatted as a decimal. Ideally I want it represented as a percent, like the green bar.
So just to clarify, after clicking on your datafield, when you go into the Modeling Tab of the ribbon, the option for "Format" is greyed out? I understand that Data Type should be greyed out, but my expectation is that the formatting options should still be available to you. Is the % button also greyed out?
I note that your other field is already being formatted as a percentage. This incidates to me that the formatting has been applied to that field.
Before I was only clicking on the chart, and not the measure. This time, as you suggested, I clicked the measure from the "fields" list and was able to format the chart properly.
Thank you for your help!