Forum Discussion
How to Set Column-Specific or Line-Specific Maximum Values for Data Bars in a Power BI Matrix?
Hello Slim,
Unfortunately it doesn't work. What I would like is to change the reference of what would be the maximum value of my bar graph for each cell in the table. Using the standard feature of the Matrix object in Visual > Cell Elements > Data Bars, the maximum reference of the bar chart is the entire filtered table. I would like to change this maximum reference per column, not the entire table.
As for more information about the dataset, it can be thought of as any simple table. If a simple table, activate this feature in Visual > Cell Elements > Data Bars, the visual will be like what I shared.
Does this help?
Sorry, indeed I had not read it correctly,
I do not think that it is possible : you can only use the maximum of the whole set, or a fixed maximum that you set up for the whole set in a Matrix.
However you could use a table instead and by creating new measures (using calculate and filter) you could plot the same data and set the maximum of bar chart for each column added in the table.
By doing this you are unfortunately losing your hierarchy on lines so I do not think that it will suit you.
Let me know if I am not clear,
Regards,