Forum Discussion

AjithReddy049's avatar
AjithReddy049
Frequent Visitor
3 years ago
Solved

TOP3 and Bottom 3

Hi Team,   I have some scenarios, Here I would like to highlight to where ever we have sales data more than 17% Green   less than 3% Red remaining Blue, case by using selected slicer values we wou...
Need Help
  • Anonymous's avatar
    Anonymous
    3 years ago

    Hi AjithReddy049 ,

     

    You can create a measure as follows.

    Measure = var _amount=SUM('Table'[Sales Amount])
var _all=CALCULATE(SUM('Table'[Sales Amount]),ALLSELECTED('Table'))
var _percent=DIVIDE(_amount,_all)
return SWITCH(TRUE(),_percent>0.17,"green",_percent<0.03,"red",_percent<=0.17&&_percent>=0.03,"blue")

    Go to the following setting and click "fx".

    Select "Field value" in Format Style and then choose the measure just created.

    Click OK, the result is below.

     

     

    Best Regards,

    Stephen Tao

     

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

     

     

TomMartens's avatar
TomMartens
Super User
3 years ago

Hey AjithReddy049 ,

 

I'm wondering if you tried "Color by rules" as described in this article: https://learn.microsoft.com/en-us/power-bi/create-reports/desktop-conditional-table-formatting?WT.mc_id=DP-MVP-5003068

 

Of course, instead of using the table formatting option, you start the conditional formatting here, because it's column chart:

Besides that, the article is also valid for column charts.

Hopefully, this gets you started, if not, please describe why "Color by rules" can not be applied to your problem.

 

Regards,

Tom

AjithReddy049's avatar
AjithReddy049
Frequent Visitor
3 years ago

TomMartens  in my case I would like to show variations in bar color if  > 80% Green, >60 to <30 Blue, and>30 Red like that, is there any possibility we can achieve this thing in bar chat?

 

thanks & Regards,

Ajith Reddy

  • TomMartens's avatar
    TomMartens
    Super User
    3 years ago

    Hey AjithReddy049 ,

    did you check the article?

    If not, please describe why not and also provide sample data and explain the expected result based on the sample data you provide.

     

    Regards,

    Tom

  • Anonymous's avatar
    Anonymous
    Not applicable
    3 years ago

    Hi AjithReddy049 ,

     

    You can create a measure as follows.

    Measure = var _amount=SUM('Table'[Sales Amount])
var _all=CALCULATE(SUM('Table'[Sales Amount]),ALLSELECTED('Table'))
var _percent=DIVIDE(_amount,_all)
return SWITCH(TRUE(),_percent>0.17,"green",_percent<0.03,"red",_percent<=0.17&&_percent>=0.03,"blue")

    Go to the following setting and click "fx".

    Select "Field value" in Format Style and then choose the measure just created.

    Click OK, the result is below.

     

     

    Best Regards,

    Stephen Tao

     

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