Show current value in matrix

[dt]

Hello,

I have table with hierarchy data.

Question 1: How-to show current value of fields Assigned To, Customer, State instead first or later?

Question 2: How-to hide null row in drill down?

Question 3: How-to disable bold font in drill down?

Attach file: Hiararchy.pbix

Thanks.

[v-juanli-msft]

Hi @dt 

Question 1: How-to show current value of fields Assigned To, Customer, State instead first or later?

the "first or later" don't affect the real data. just right click on the field name and select "rename".

Question 2: How-to hide null row in drill down?

the "null" in your table is of text type, to hide them , you could open "transform data", then "ctrl+alt+a" select the whole table, next replace "null" with null(means blank)

If you want all null rows to hide in the matrix, please edit visual level filter as below:

Question 3: How-to disable bold font in drill down?

This is by design , i don't find any setting to change it.

Best Regards
Maggie
Community Support Team _ Maggie Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[dt]

Hi, @v-juanli-msft

Question 2 and 3 - resolved, thanks.

How show correct value?

Now is incorrect:

[dt]

@v-juanli-msftany idea?

[dt]

Anybody help me?

@v-juanli-msft no ideas?

[v-juanli-msft]

Hi

How about unpivot columns?

finally data structure is like

row_hierarchy1   row_hierarchy2  ...   columns_names    columns_value

then add "row_hierarchy" in "row", add "columns_names" in "column", "columns_value" in "value".

Best Regards

Maggie

[v-juanli-msft]

Hi

Sorry, i tried but can't get the correct result as you expected.

Best Regards

Maggie