Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
Galat198
Helper IV
Helper IV

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.

Galat198_0-1612793515102.png

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?

5 REPLIES 5
negi007
Community Champion
Community Champion

@Galat198 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. 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Hi @Galat198 ,

 

v-lionel-msft_0-1612937425731.png

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.

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

negi007
Community Champion
Community Champion

@Galat198 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_0-1612796987529.png

 




Did I answer your question? Mark my post as a solution!
Appreciate your Kudos



Proud to be a Super User!


Follow me on linkedin

Hi @negi007 
What visual is this?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.