Feature Request: Matrix Visual

[bradbel]

Posting about two (very specific) feature requests for Power BI Matrix visuals:

1. Total Row at Top: In Tabular Format, you cannot place the Total Row at the top of the table for whatever reason... this is not ideal as when you have a table that exceeds the display boundaries you must scroll down to see the total row. I'm pretty sure you used to be able to have a tabular-type format with the total row at the top and it was changed

2. Per-Value-Column Sorting with Calculation Items: I'm sure this is more of a technical limitation, but I'm also sure there is a possible solution that could be built in. When displaying multiple calculation items in a Matrix visual, you cannot sort by any of the value columns, only by the base underlying table sum value column. This is not ideal and negates the purpose of calculation groups for many applications with matrix visuals

I'm almost certain that solutions to these issues do not exist but please comment if you are aware of a solution.

[v-achippa]

Hi @bradbel,

Thank you for reaching out to Microsoft Fabric Community.

Thank you @lbendlin, @Murtaza_Ghafoor, @krishnakanth240 and @tharunkumarRTK for the prompt response.

As we haven’t heard back from you, we wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[v-achippa]

Hi @bradbel,

We wanted to kindly follow up to check if the solution provided by the user's for the issue worked? or let us know if you need any further assistance.

Thanks and regards,

Anjan Kumar Chippa

[tharunkumarRTK · Accepted solution]

@bradbel 

Regarding the second feature, "Per-Value-Column Sorting with Calculation Items"

I would like to suggest a workaround

I have a Matrix visual with the “Continent” column placed in the Rows well, the “Time Calc” column (in this scenario column is taken from a calculation group table, however same workaround can be used even when the column is taken from a normal table) placed in the Columns well, and “Sales Amount” placed in the Values well, as shown below.

I wanted to sort the Continents based on the QTD value in descending order.

By default, the Matrix visual does not support per-value sorting. In this scenario, you can follow the trick below to achieve this.

1. Create a a new DAX measure
   SortingMeasure =
   Var __CYRank = RANK(DENSE, ALLSELECTED(Customer[Continent]), ORDERBY(Sales[Sales Amount],DESC))
   Var __CalcItem = SELECTEDVALUE('Time Intelligence'[Ordinal],0)
   Var __ReturnOnlyIfCY = IF(__CalcItem = 3, __CYRank) // For QTD the ordinal value is 3
   Return __ReturnOnlyIfCY  ​
2. Add this measure to the Matrix Values well
   
3. Sort the Matrix visual based on SortingMeasure. 
   
4. Once the desired sorting is achieved, it is very important to hide the sorting measure from the Matrix.
5. Change the format string of SortingMeausre to Dynamic and use the following expression:
   UNICHAR(127)​
   

This hides the value of the sorting measure.

6. At the visual level, rename SortingMeasure, Sales Amount, and Continentto a blank space, and rename the Time Calc column to “Continent”.

That’s it! You are now able to perform per-value sorting in a Matrix visual.

Connect on LinkedIn

you can read my blogs here: https://techietips.co.in

Did I answer your question? Mark my post as a solution!
If I helped you, click on the Thumbs Up to give Kudos. Proud to be a Super User!

[krishnakanth240]

Hi @bradbel 

Total Row at Top - Totals can only appear at the bottom. So, workaround is we can create a measure card or table visual above the matrix to show totals.

Sorting by Calculation Items - Power BI cannot sort matrix columns created from calculation groups individually. Sorting only works based on underlying measure. Workaround is creating measures instead of calculation items, or using a column for the sorting.

Both are current limitations of Power BI Matrix visuals and there is no native solution yet and only workarounds.

[Murtaza_Ghafoor]

@bradbel 
For any new idea you need to submit that i fabric ideas portal and get votes, thanks
https://community.fabric.microsoft.com/t5/Fabric-Ideas/idb-p/fbc_ideas

[lbendlin]

If this is important to you please consider voting for an existing idea or raising a new one at https://ideas.fabric.microsoft.com

[Ashish_Mathur]

Hi,

It would also be nice to add calculations (measures and visual calculations) in the rows well of the matrix visual.  A use case being adding a Serial number column (via a visual calculation) to a mtrix visual.