Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Cholo
Regular Visitor

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 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

 

Cholo_0-1709736944355.png

 

 

Data Source Below:

 

Respondent CategoryPPMs L12M:PPMs L12M Remarks:PPMs L3M:PPMs L3M Remarks:Sub-Tier Supplier Management:Sub-Tier Supplier Management Remarks:
Manufacturer6TEST ONLY9TEST ONLY1TEST ONLY
Supplier7TEST ONLY7TEST ONLY2TEST ONLY
       
       
EXPECTED OUPUT:      
Questions:Manufacturer RateSupplier Rate    
PPMs L12M67    
PPMs L3M97    
Sub Tier72    

 

1 ACCEPTED SOLUTION
lbendlin
Super User
Super User

Your data source is in a bad shape and needs to be unpivoted to make it usable.

lbendlin_0-1709839007073.png

 

Then you can load it into Power BI and use a matrix visual

 

lbendlin_1-1709839207588.png

 

 

View solution in original post

4 REPLIES 4
lbendlin
Super User
Super User

Your data source is in a bad shape and needs to be unpivoted to make it usable.

lbendlin_0-1709839007073.png

 

Then you can load it into Power BI and use a matrix visual

 

lbendlin_1-1709839207588.png

 

 

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. 

 

Cholo_0-1710264867345.png

 

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

Great! This works, appriciate your support on this @lbendlin  😊

Helpful resources

Announcements
Sept PBI Carousel

Power BI Monthly Update - September 2024

Check out the September 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

Sept NL Carousel

Fabric Community Update - September 2024

Find out what's new and trending in the Fabric Community.

Top Kudoed Authors