Forum Discussion

Cholo's avatar
Cholo
Regular Visitor
2 years ago
Solved

TABLE VISUAL - NOT SHOWING CORRECT VALUE

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 c...
@custom visuals
@need help
@Power BI
@tables
new user
  • lbendlin's avatar
    lbendlin
    2 years ago

    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

     

     

     

Cholo's avatar
Cholo
Regular Visitor
2 years ago

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:RangeManufacturer RateSupplier Rate
PPMs L12M0 - 1067
PPMs L3M0 - 1097
Sub Tier0 - 1072

 

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. 

 

 

lbendlin's avatar
lbendlin
Super User
2 years ago

Use a fake aggregation like MAX, MIN, or AVERAGE when you add that column to the values area of the matrix.

  • Cholo's avatar
    Cholo
    Regular Visitor
    2 years ago

    Great! This works, appriciate your support on this lbendlin  ğŸ˜Š