% completeness in matrix bars

[Fern_21]

Hi all!

In the values of a matrix, I have a measure that calculates the completion percentage.

I've noticed that the highest value, whether it's 80% or 100%, is always colored the same way. Is there a way to set 100% as the maximum value, so that if the percentage is 80%, the bar isn't completely filled?

Thank you very much.

[v-saisrao-msft]

Hi @Fern_21,

We haven’t heard back from you regarding your issue. If it has been resolved, please mark the helpful response as the solution and give a ‘Kudos’ to assist others. If you still need support, let us know.

Thank you.

[v-saisrao-msft]

Hi @Fern_21,

May I ask if you have resolved this issue? If so, please mark the helpful reply and accept it as the solution. This will be helpful for other community members who have similar problems to solve it faster.

Thank you.

[danextian]

Hi @Fern_21 

The data bar always uses the full width for the row with max value. The rest are relative to this. A roundabout way is to use a DAX-generated SVG image. You can find samples here https://community.fabric.microsoft.com/t5/Data-Stories-Gallery/SVG-as-data-bars-in-tables-and-matric...

[Fern_21]

Hi @danextian !

Thanks for your answer.

Is it possible to insert a custom value? Is there a way to set the maximum value to 100%?

[v-saisrao-msft]

Hi @Fern_21,
I wanted to check if you had the opportunity to review the information provided by @danextian @kushanNa. Please feel free to contact us if you have any further questions. If the response has addressed your query, please accept it as a solution and give a 'Kudos' so other members can easily find it.
Thank you.

[danextian]

You can use 0  and 1 if you're dealing with percentages. If with numbers, you add some amount to the max but this is a manual process and your max amount can always change depending on the data.

[kushanNa]

Hi

Tried making Minimum custom value as 0 and maximum 1 ?