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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Simple_tuition1
Frequent Visitor

Matrix Visual: Data Bars Max Value based on Columns

Hi,

 

Currently I have a column called "Sales Percentage" and another column with "Country" in my table. Visualized in a matrix it looks like this below. The columns are set to be shown as rows. The Columns "Total Sales" and "Sales Percentage" have been added to Values, Country to Column and Product & Salesperson to Row  in the matrix visual.

Simple_tuition1_0-1673510393615.png

 

The data looks like this. It's just dummy data for visualization purposes:

 

SalespersonCountryProductSales PercentageTotal Sales
GinaCanadaCity Bike0.02232
GinaCanadaMountain Bike0.562800
GinaItalyCity Bike0.32213
GinaItalyMountain Bike0.211050
GinaUSACity Bike0.11122
GinaUSAMountain Bike0.432150
JohnCanadaCity Bike0.32333
JohnCanadaMountain Bike0.34442
JohnItalyCity Bike0.122132
JohnItalyMountain Bike0.671233
JohnUSACity Bike0.223300
JohnUSAMountain Bike0.457300
MaryCanadaCity Bike0.21121
MaryCanadaMountain Bike0.532650
MaryItalyCity Bike0.32213
MaryItalyMountain Bike0.12600
MaryUSACity Bike0.11123
MaryUSAMountain Bike0.12600

 

 

Would it be possible to create different max data bars values through conditional formatting for each country? For example max value for Canada is at 35% and the data bar is full at 35 %. Then for Italy 40 % and USA 50 %. Currently it seems like I can only enter a max and min value for the whole column "Sales Percentage" Column and the databar max value would be the same for each Country.

 

It should look like this afterwards but the data bars should have different max values. It should be full for Canada when it is over 35%, full for Italy over 40%, USA over 50%. Like written above when I right click on the percentage column to create a data bar I can only enter one user defined max and min value for the whole "Sales Percentage" Column:

Simple_tuition1_1-1673510508213.png

 

5 REPLIES 5
SSMEMLE
Frequent Visitor

Did you find a solution?

 

bolfri
Super User
Super User

Can you paste here sample datasource for this table so we don't need to rewrite this? And also an table (might be in excel) with expected results? 🙂 It will be easier for everyone to understand what do you want to achive.





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

Proud to be a Super User!




I have updated the post. I hope it's more clear now

1Daniel993
Helper III
Helper III

Do you want something like about totals by countrys?

I would like to create Data bars for the "Sales Percentage" Column in the matrix visual but with different maximum values for the databar to be "full" based on the Countries. 

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

July 2024 Power BI Update

Power BI Monthly Update - July 2024

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

July Newsletter

Fabric Community Update - July 2024

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