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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

Reply
Hasvine2022
Helper I
Helper I

Matrix table issue on online power bi

Hi Team,

 

I am having an issue with a matrix table.

 

On my power bi desktop, I have a matrix table containing 1800 lines as columns and 220 lines in my row.

 

However, when I published the table online, my table had only 60-row lines.

 

I tried multiple times but got the same result.

 

Show items with no data is ticked on both the row and column field.

 

Any idea how I can resolve this issue?

 

Thank you.

 

Kind Regards,

 

Hasvine

 

3 REPLIES 3
v-shex-msft
Community Support
Community Support

Hi @Hasvine2022,

Can you please share some more detail information about this issue? (e.g. data source type, connection mode, matrix design and calculate fields)They should help us clarify your scenario and test to troubleshoot.

How to Get Your Question Answered Quickly  

Regards,

Xiaoxin Sheng

 

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Hello Xiaoxin,

 

Thank you for your reply. I work for a fast moving consumer group and we have around 200 products and around 2000 customers.

 

I am trying to create an matrix table showing customers in row and product in columns and as value, I would like to show the quantity sold.

 

Some products have not been sold yet while some customers in the database haven't ordered yet.

 

Basically I need the matrix table so that the sales team can identify which which point of sales have not ordered yet.

 

I have a table called Client containing all 2000 clients and a table called Products with all 200 products. I have also a sales_main table with the sales information such as quantity, amount etc...

Only sold products will be available in the sales_main table. However, I need to make sure that even those products and retailers where no sales was recorded shows on matrix table.

 

I am able to somehow build the table on powerbi desktop but when i load it online, the column table is restricted to 60 only.

 

I have created a crossjoin table but still does not work on the online power BI.

 

I did a dummy .pbix but unfortunately I cannot upload it.

 

Please let me know if you require any additional information.

 

Thank you for your help.

 

Kind Regards,

 

Hasvine

Hi @Hasvine2022,

The auto hide is the default Power bi aggregate features.
Power bi will auto hide the row/column which whole row or column does not include any correspond records. If you want force show all item, you can click on the category fields to choose ‘show items with no data’.

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Power BI Monthly Update - May 2024

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