Forum Discussion
TABLE VISUAL - NOT SHOWING CORRECT VALUE
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
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.