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

Be one of the first to start using Fabric Databases. View on-demand sessions with database experts and the Microsoft product team to learn just how easy it is to get started. Watch now

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
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Dec Fabric Community Survey

We want your feedback!

Your insights matter. That’s why we created a quick survey to learn about your experience finding answers to technical questions.

ArunFabCon

Microsoft Fabric Community Conference 2025

Arun Ulag shares exciting details about the Microsoft Fabric Conference 2025, which will be held in Las Vegas, NV.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.

Top Kudoed Authors