Forum Discussion

MVaughan1's avatar
MVaughan1
Frequent Visitor
8 years ago
Solved

Dynamically changing assumptionss from Report view

Hello, I am trying to find a way of displaying assumptions that can be changed in the Report view.   I cannot share my data for confidentiality, but here is a representative sample of the data   ...
  • MVaughan1's avatar
    MVaughan1
    8 years ago

    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

MVaughan1's avatar
MVaughan1
Frequent Visitor
8 years ago

Hi again kohlivinayak

 

Rev vs PY (Risk) = IF('Finance data (2)'[vs PY]<[Tolerance Value],1,0)

 

If I swap [Tolerance Value] for eg "0.1", the values change. 

 

This is my Tolerance Measure

 

Tolerance Value = SELECTEDVALUE(Table1[Rev Tolerance])

 

And below I have shown a picture of the Rev Tolerance table.

 

 

 

 

 

 

 

kohlivinayak's avatar
kohlivinayak
Resolver I
8 years ago

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.

  • MVaughan1's avatar
    MVaughan1
    Frequent Visitor
    8 years ago

    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