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

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

HI nileshroy1

 

Have a quick look at the attached PBIX file.  If you select more (or fewer) items on the slicer the color of the column will change once you go over/under 60

 

 

  • 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