Forum Discussion
Dynamically changing assumptionss from Report view
Hi kohlivinayak,
I have got this to work, not because of the decimal but because my formula was in a calculated column rather than a measure.
The Selected Value and IF HAS ONE VALUE functions both seem to rely on measures. Not sure if this is basic Power BI chapter 1 that I skipped over but certainly a key learning point for me. What is a bit of a pain is that it seems as though I will have to convert all my existing columns into measures. I got this to work by changing my vs PY to a "SUM vs PY" measure.. I don't really understand why this is needed, but I shouldn't take any more of your time on this.
Thanks once again, really appreciate your help.
Mark
The value you are puting in rev table is text.
Please change it to 0.1, 0.2, 0.5 as such decimal values. (check data type before exiting the edit query, it should be decimal)
In the modeling tab you have an option to display it as % where it will multiply the number with 100 and add a % in end of it by default.
Select the column name on the right side, go to modeling tab and below format just select % option.
Hi kohlivinayak,
I have got this to work, not because of the decimal but because my formula was in a calculated column rather than a measure.
The Selected Value and IF HAS ONE VALUE functions both seem to rely on measures. Not sure if this is basic Power BI chapter 1 that I skipped over but certainly a key learning point for me. What is a bit of a pain is that it seems as though I will have to convert all my existing columns into measures. I got this to work by changing my vs PY to a "SUM vs PY" measure.. I don't really understand why this is needed, but I shouldn't take any more of your time on this.
Thanks once again, really appreciate your help.
Mark