% completeness in matrix bars

Question

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.

danextian · Answer

Hi Fern_21&nbsp;
&nbsp;
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-matrices/m-p/3835955

&nbsp;

fern_21 · Answer

Hi&nbsp;danextian&nbsp;!Thanks for your answer.Is it possible to insert a custom value? Is there a way to set the maximum value to 100%?&nbsp;

kushanna · Answer

Hi&nbsp;Tried making Minimum custom value as 0 and maximum 1 ?&nbsp;&nbsp;&nbsp;

danextian · Answer

You can use 0&nbsp; 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.

&nbsp;

v-saisrao-msft · Answer

Hi Fern_21,I wanted to check if you had the opportunity to review the information provided by danextian&nbsp;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.

Forum Discussion

% completeness in matrix bars

7 Replies

Related content

Refresh completed with warnings

How create a stacked bar chart 100% completion Line?

Refresh completed with warnings

Matrix table

Slicer Search Bar