Forum Discussion

dt's avatar
dt
Frequent Visitor
6 years ago

Show current value in matrix

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.

Need Help

6 Replies

  • v-juanli-msft's avatar
    v-juanli-msft
    Community Support
    6 years ago

    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.