cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Anonymous
Not applicable

Matrix and drilled records and sort

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
7 REPLIES 7
amitchandak
Super User
Super User

@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

Did I answer your question? Mark my post as a solution! Appreciate your Kudos!! !!
Dashboard of My Blogs !! Connect on Linkedin
Want To Learn Power BI
Learn Power BI Beginners !! Advance Power BI Concepts !! Power BI For Tableau User !! Learn Power BI in Hindi !!
Proud to be a Super User!
Anonymous
Not applicable

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)

Hi  @Anonymous ,

 

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

Annotation 2020-07-17 153914.png

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

Annotation 2020-07-17 155913.png

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:

Annotation 2020-07-17 160146.png

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
Not applicable

Hi, @v-kelly-msft

 

Thanks for You answer, but:

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

powerbi.JPG

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.

 

Hi @Anonymous ,

 

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

Annotation 2020-07-20 083239.png

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

Annotation 2020-07-20 083514.png

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

Annotation 2020-07-20 083750.png

 

Best Regards,
Kelly
Did I answer your question? Mark my post as a solution!
Anonymous
Not applicable

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
Super User
Super User

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!

 

Helpful resources

Announcements
2022 Release Wave 1 760x460.png

2022 Release Wave 1 Plan

Power Platform release plan for the 2022 release wave 1 describes all new features releasing from April 2022 through September 2022.

Power BI December 2021 Update_carousel 768x460.jpg

Check it Out!

Click here to read more about the December 2021 Updates!

Top Solution Authors