Forum Discussion

albertgarri's avatar
albertgarri
Frequent Visitor
9 years ago
Solved

Changing column graph displayed value

Hi everyone!    I'm pretty new to power bi world, so my question might be obvious for most of you.  My goal is to create an element similar to the one with the red box, that you can see on the f...
Need Help
  • v-huizhn-msft's avatar
    v-huizhn-msft
    9 years ago

    Hi albertgarri,

     

    I am sorry for inconvenience, I misunderstand your idea in above reply. The solution above is to create a new table using formula. While in this solution, please click the Enter Date, you will get the create table window, please type the values, you can rename the table name in highlighted background section. Click OK  you get Table4.

     

     

     


    In the DAX formula, "Expected Value" is the measure name. Please right click your table->New measure, type the following statement is over-all.

     

    Expected Value = 
IF(HASONEVALUE( Table3[Value]),
 SWITCH(VALUES( Table3[Value]),
 "Amount", SUM( Table4[Amount] ),
 "Amount spent", SUM( Table4[Amount spend] ),
 "Price per unit", SUM( Table4[Price per Unit] )
 ), "Please select only one value to display")

    In your scenario, please replace Table3 name using your actual table name. Table4 is the new table name. Please replace it using your table name.

    If you have any other issue, please let me know

     

    Best Regards,
    Angelia

BetterCallFrank's avatar
BetterCallFrank
Resolver IV
9 years ago

Hi albertgarri

 

what you describe is possible, however not the most easy beginner topic ;)

 

here's what needs to be done:

 

1. create helper table without relationship with 1 col, 3 rows

 

Value

----

Amount

Amount Spent

Price per Unit

 

2. create a measure in your table1 e.g.

DisplayValue =
IF(HASONEVALUE( 'Value'[Value])
  SWITCH(VALUES( 'Value'[Value] ),
    "Amount", SUM( Table1[Amount] ),
    "Amount Spent", SUM( Table1[Amount Spent] ),
    "Price per Unit", SUM( Table1[Price per Unit] )
  ), "Please select only one value to display")

something similar will do the trick for you.

 

3) pull new measure "DisplayValue" into your visual intead of "Amount" etc.

 

HTH,

Frank

ivancespedesl's avatar
ivancespedesl
Helper I
7 years ago

Hi,

 

I followed all the steps and got everything correct. However, i want to get more information and I would like to have some MoM%, average, and other kind of calculations for all these measures. I have tried to do it using time intelligence in quick measure, but these seem not to work.

 

Could you please help me to make some calculations with this "macro" measure?

 

 

Regards,
IC