Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started
Hello Everyone,
I'm a newbiew working on a BI report, I want to show/display the header (Questions) as rows. Then categorize it now by 2 columns which is Manufacturer Rate & Supplier Rate. The concern is I use a filter to sort/display the result below by using the respondent category and supplier name. If this question was raise before and resolved please help me redirect to that same question. Appriciate any support provided.
Sample I will use the following filter;
Respondent = Manufacturer, Supplier = ABC Enterprise.
The expected output should be like, on
Question | Manufacturer Rate | Supplier Rate
PPM's L12M | 6 | 7
Data Source Below:
Respondent Category | PPMs L12M: | PPMs L12M Remarks: | PPMs L3M: | PPMs L3M Remarks: | Sub-Tier Supplier Management: | Sub-Tier Supplier Management Remarks: |
Manufacturer | 6 | TEST ONLY | 9 | TEST ONLY | 1 | TEST ONLY |
Supplier | 7 | TEST ONLY | 7 | TEST ONLY | 2 | TEST ONLY |
EXPECTED OUPUT: | ||||||
Questions: | Manufacturer Rate | Supplier Rate | ||||
PPMs L12M | 6 | 7 | ||||
PPMs L3M | 9 | 7 | ||||
Sub Tier | 7 | 2 |
Solved! Go to Solution.
Your data source is in a bad shape and needs to be unpivoted to make it usable.
Then you can load it into Power BI and use a matrix visual
Hello @lbendlin,
I really appriciate your support on my concern above. I was able to show now the data I need 😊
Just one more concern what if, I want to show each question range value, how I can show the columns also?
Since on the actual report the respondent category should be drag on columns. I was thinking if should I just create a new table with range per each question and lookup it? But its seems like not working on a matrix table. Do you have any thoughts on this?
EXPECTEDOUPUT: | |||
Questions: | Range | Manufacturer Rate | Supplier Rate |
PPMs L12M | 0 - 10 | 6 | 7 |
PPMs L3M | 0 - 10 | 9 | 7 |
Sub Tier | 0 - 10 | 7 | 2 |
When I tried to drag the RANGE column into ROWS from new table I created with values, which I just use the questions as their relationship since each questions are unique. This was the actual report looks like, the range values are under its question which I want to be as columns too if possible.
Use a fake aggregation like MAX, MIN, or AVERAGE when you add that column to the values area of the matrix.
Check out the September 2024 Power BI update to learn about new features.
Learn from experts, get hands-on experience, and win awesome prizes.
User | Count |
---|---|
27 | |
11 | |
8 | |
6 | |
6 |