Matrix and drilled records and sort

[Anonymous]

Hi,

I cant found in searche Q&A for My problem.
 
I have Queries, who have 10 columns. I create Matrix everything is ok, but when I wan click to see records, I go to next table.

There is problem:
1. How to sort colums, for my ideas,
2. How to remove colums on this view, but not hide,
3. How to use colors row or text,  when I wan to show special value?

BR

Lukas

[amitchandak]

@Anonymous ,

1. How to sort colums, for my ideas,

For values/measure, you can only sort on the grand total In case of pivot (have column). You can sort on row-column or measure by clicking on them or using three dots.

https://docs.microsoft.com/en-us/power-bi/visuals/desktop-matrix-visual
2. How to remove columns on this view, but not hide,

You can filter value using the visual level filter. Question is not very clear
3. How to use colors row or text,  when I wan to show special value?

You have to color all column using the same rule, there is no row coloring

https://radacad.com/dax-and-conditional-formatting-better-together-find-the-biggest-and-smallest-numbers-in-the-column
https://docs.microsoft.com/en-us/power-bi/desktop-conditional-table-formatting#color-by-color-values

[Anonymous]

I know how the Matrix works (color,tabel, sort by value), but the Matrix has a different tabels below it.

After clicking on the value in the matrix (right mouse button) "see  records", You go to another tabel.

And my 3 question concerns this tabel

Maybe I didn't write it clearly, sorry

1. How to sort columns, for my ideas, sort all columns (sort by column name), not column values,
2. How to delete columns in this view, but not hide it. (When you're in the secondary tabel)
3. How to use colors row or text,  when I wan to show special value? (When you're in the secondary tabel)

[v-kelly-msft]

Hi  @Anonymous ,

1.Go to top right corner of the "table",and you will see sort by:

2.Delete columns: Go to field>remove the columns you wanna delete:

3. use colors row or text

Based on my test, the secondary table is only a table,it only have 3 features,sort,delete or add columns,but it cant format:

If you do wanna have the feature,I suggest you propose your new idea via below link with your comments there to make this feature coming sooner.

https://ideas.powerbi.com/forums/265200-power-bi-ideas

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

Hi, @v-kelly-msft

Thanks for You answer, but:

1. You only sort for Value, I want sort Columns:

The second answer, You can do this only when You open report on Power BI desktop, if You open on website, You don't have this options, but I want do it once, and manager when cliked "see record" always will see tabel, with removed columns, and only remove on this view  

The thir answer - ok.

[v-kelly-msft]

Hi @Anonymous ，

1.Go to report in website>click ...>choose edit:

Then right click on the table>"show as a table",and you will see the visualization pane on the right:

2.If you wanna sort the columns,go to the visualization pane>field>just move the columns up or down as you need:

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

[Anonymous]

HI, @v-kelly-msft 

AD 1. You have Azure. I have on-premises, I don't have this option.
AD 2. You change it in Power BI Desktop so I guess, if you open on website you don't have this option, if you change it under Power BI Desktop, you will exit this view, then enter, these changes will not be saved..

[harshnathani]

Hi @Anonymous ,

Not very clear

See if this helps

https://community.powerbi.com/t5/Desktop/sorting-in-drill-down-matrix/m-p/295917

https://community.powerbi.com/t5/Desktop/Matrix-Custom-Sort/m-p/698564

Regards,

Harsh Nathani

Appreciate with a Kudos!! (Click the Thumbs Up Button)

Did I answer your question? Mark my post as a solution!