Forum Discussion

nileshroy1's avatar
nileshroy1
Frequent Visitor
8 years ago
Solved

KPI Visual similar to Column Chart with conditional colour formatting option

Hi All,   I have a requirement to display an KPI Visual which should look like a Stacked Column Chart, please see image below:      However, it should display GREEN when the VALUE is less ...
  • v-piga-msft's avatar
    v-piga-msft
    8 years ago

    Hi nileshroy1,

     

    By my test with many graphs, it seems that there is no better graph to meet your requirement in Power BI currently.

     

    For another option, You may have a try with the custom visual Slim Data bar KPI which is similar with the chart  LINEAR GUAGE by MAQ Software.

     

     

    If that still don't meet your requirement,  I suggest you could try with table visualization which have the conditional formatting.

     

    Best regards,

    Cherry

v-piga-msft's avatar
v-piga-msft
Icon for Resident Rockstar rankResident Rockstar
8 years ago

Hi nileshroy1,

 

By my test with many graphs, it seems that there is no better graph to meet your requirement in Power BI currently.

 

For another option, You may have a try with the custom visual Slim Data bar KPI which is similar with the chart  LINEAR GUAGE by MAQ Software.

 

 

If that still don't meet your requirement,  I suggest you could try with table visualization which have the conditional formatting.

 

Best regards,

Cherry

  • nileshroy1's avatar
    nileshroy1
    Frequent Visitor
    8 years ago

    Thanks v-piga-msft,

     

    That was very helpfull, it is able represent data in a similar way but horizontally instead of vertically.

     

    Is there a way to make the visual vertical, I tried it's Orientation Option but it does not change.

     

    Also is there a way to get it's code to enhance it?

     

    Cheers

    NR