Learn from the best! Meet the four finalists headed to the FINALS of the Power BI Dataviz World Championships! Register now
Hi All,
I need one logic in matrix Visual.
I have one table that have Item and Value Columns.
Item column have Multiple Rows and One row called "Pencil".
Value Column Contains Item's Values.
These are located in Matrix Visual.
I need to Show the Item Column's row "Pencil" is anytime Place into the first row of the Matrix. If i sort values column in matrix table descending or ascending order the "Pencil" row is always shows in first row of the Matrix.
Is it Possible?
(OR)
The Row Grand total of the Matrix contains Pencil Values? So, We can anytime saw the values in first Row of the Matrix. In this logic the Category is not equal "Pencil" is applied in Filter Pane. Because the Grand total Contains "Pencil" Rows. So we need to hide this "Pencil" Row in the Matrix Visual.
Is it Possible?
Please help me.
Thanks in Advance.
@Anonymous Sorry, having trouble following, can you post sample data as text and expected output?
Not really enough information to go on, please first check if your issue is a common issue listed here: https://community.powerbi.com/t5/Community-Blog/Before-You-Post-Read-This/ba-p/1116882
Also, please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490
The most important parts are:
1. Sample data as text, use the table tool in the editing bar
2. Expected output from sample data
3. Explanation in words of how to get from 1. to 2.
| User | Count |
|---|---|
| 58 | |
| 46 | |
| 31 | |
| 17 | |
| 16 |
| User | Count |
|---|---|
| 77 | |
| 66 | |
| 46 | |
| 22 | |
| 22 |