Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

How to union two measures

Hi, I have two measures. 1.sum of sales(%) 2.Goal(%)   I want to show four months of sales in a bar chart visual along with Goal bar . Something like this  as below four blue bars are su...
v-deddai1-msft's avatar
v-deddai1-msft
Icon for Community Support rankCommunity Support
6 years ago

Hi Anonymous ,

 

I suggest you use clustered column chart. And you can change your Goal(%) measure to 

 

NEWGoal(%) = IF(MAX(Table[Column]) = "FY21Q2",[Goal(%)],0)

 

And you visual will be like:

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

 

  • Anonymous's avatar
    Anonymous
    Not applicable
    6 years ago

    It showing error message as below 

    "Dax comparison operations do not support comparing values of type number with value of type text consider using the value or format function to convert one of the values."