Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Visual comparison between two columns

Hi,
I have two columns in the table with duration time.
Current Data Bars length is according to min and max value in their column.

In such a situation it is not possible to visually compare two columns, because the maximum and minimum values in each column are different. (A 2 hours and 20-minute bar look the same.)
In the settings you can adjust the size of the bar according to the minimum and maximum in the same column and not according to two columns ...


Does anyone know a better way to present a visual comparison between two columns?

Need Help

5 Replies

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous in matrix visual for comparision purpose data bar are used. in this case you can set the min and max value same for both the columns. Below is an example of the bar chart use in matrix visual

     

     

  • negi007's avatar
    negi007
    Community Champion
    5 years ago

    Anonymous this is also a matrix visual which you are using in your file. You can make it look better by formatting the matrix table and using proper color comibnation. It is upto us to take our dashboard/visual to the next level. 

    • v-lionel-msft's avatar
      v-lionel-msft
      Community Support
      5 years ago

      Hi Anonymous ,

       

      You can find custom minmum value and maximum vlaue in "Advanced controls".

       

      Best regards,
      Lionel Chen

      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
        5 years ago

        v-lionel-msft 
        This for manual entry, but I need dynamically min and max values by two columns.