Forum Discussion

Vallirajap's avatar
Vallirajap
Resolver III
2 years ago

Measure colour difference in legend

Hi All,

 

I have one doubt: I add two measures to calculate a single measure and pass the measure in a bar chart. Now it displays the values correctly.

 

Measure 3 = Measure1 + Measure2

But now I need a split like a legent in a bar chart. values of Measure1 in one color and values of Measure2 in another color.

How to get the result. 
Thanks in advance
 

Need Help
Show and Tell
Tips and Tricks

4 Replies

  • AnkitaaMishra's avatar
    AnkitaaMishra
    Super User
    2 years ago

    Hi Vallirajap ,

    Hope you are doing well.

    If my understanding is clear, then please use Stacked Column Chart and place measure1 and measure2 on the yaxis : 

     


    After that from format your visual section, you can go to column ---> select each measure (under series) and apply the color of your choice as shown below : 

     


    If this doesn't work for you, please elaborate your requirement.

    Thanks,

    Ankita

  • Vallirajap's avatar
    Vallirajap
    Resolver III
    2 years ago

    Hi AnkitaaMishra,

    Thanks for your reply. 


    But it's not like that. In my scenario, I add two measures and put them in a parameter along with more than one measure. So, I can't pass the meausres separately. 


    You may know any other options. Please share.


    Thank You

    • AnkitaaMishra's avatar
      AnkitaaMishra
      Super User
      2 years ago

      Hi Vallirajap ,

      Could you please share a PBI file with sample data and the approach you are using, it will help to understand as I am unable to replicate the requirement.

       

      Thanks,

      Ankita

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Vallirajap 

     

    Thanks for the reply from AnkitaaMishra . 

     

    Vallirajap , in my testing, I put the two measures created into the Fields parameter without adding them up, please refer to the following test.

     

    My sample:

     

    Measures:

    Measure = SUM(financials[Profit])
    Measure 2 = SUM(financials[Discounts])

     

    Parameters:

     

    Output:

     

    Best Regards,
    Yulia Xu

     

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