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

nileshroy1's avatar
nileshroy1
Frequent Visitor
8 years ago

Thanks Phil for your reply.

 

Sorry, I did not provide a test dataset to clarify the requirement.

 

The Colour of BAR is determined by comparing two incoming values.

 

The Test Data is as follows:

 

For Ex, Based on above dataset, I need to create following BAR:

 

 

If the Flow Column Value is greater it should be shown in RED.

 

Thanks

NR1

Phil_Seamark's avatar
Phil_Seamark
Icon for Microsoft Employee rankMicrosoft Employee
8 years ago

Oh ok,

 

I was taking advantage of the [color saturation] field, but that only works if you only have one metric per column.  Sorry