Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
3 years ago

Data bar highest value

Hi,

 

Is it possible to put in the highest value of a data bar based on a different column?

 

 

Need Help

8 Replies

  • v-jianboli-msft's avatar
    v-jianboli-msft
    Community Support
    3 years ago

    Hi Anonymous ,

     

    Which visual are you using?

    If the Data bar supports conditional formatting, you can try using conditional formatting.

    If conditional formatting is not supported, you may not be able to achieve your idea by using the current visual.

     

    Best Regards,

    Jianbo Li

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

    • Anonymous's avatar
      Anonymous
      Not applicable
      3 years ago

      Hello @Jianbo,

       

      I am using the table and matrix table visuals.

       

      Is it possible? I have a "Stock level" column, and a "Reorder level" column. I would like the stock level column use data bars, and the highest value is taken from the Reorder level column.

       

      Thanks for the reply.

      • v-jianboli-msft's avatar
        v-jianboli-msft
        Community Support
        3 years ago

        Hi Anonymous ,

         

        To my knowledge, your requirement could not be realized currently. An idea similar with what you expect has been submitted here, please vote it up and you can add comments. Hopes Power Bi will implement this in nearby future.

        Besides, here is a workaround:

        First add the Reorder level and rename it:

        Conditional format it to data bar:

        Output:

         

        Best Regards,

        Jianbo Li

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