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
DW868990
Helper IV
Helper IV

Deneb - Axis not showing all subcategories

Hi,

Any Deneb users - 

My x axis seems to not be showing all of the categories only a certain number of them.

When i select the subcategories individually from the filter pane they show, but when all is selected not all of them show in the visual.

Sure its a slight tweak in the code i am missing.

Thanks in advance.

 

JJ

1 ACCEPTED SOLUTION
dm-p
Super User
Super User

Hi @DW868990,

This is hard to solve without knowing anything about your specification or your data, so I can take a stab at it, but if I'm not right, you may need to provide more details about your situation so that we can see if anything else sticks out.

The initial thing that comes to mind is the potential number of rows in your dataset. For performance reasons, Deneb limits queries to 10,000 rows, so if some categories turn up when filtering and then don't for other situations, this might be worth exploring. You can set a property to turn this limit off, and recursively load more data from the model, but please bear in mind that it is (a) dependent on how many rows Power BI decides to give the visual, and (b) the performance of the specification, particularly if you're looking to display a high-number of marks.

Power BI and DAX is generally not great with high-cardinality datasets, so the combination of a + b may be limiting for you. If your visual takes a long time to load the data before its visualised, this is certainly a limitation of the query that Power BI produces, and not something we can change from within a custom visual due to that fact that they cannot specify the DAX to execute (as they are not permitted to know about the data model).

If this does turn out to be your issue, it's not recommended that you have this setting enabled while developing your visual and switch it on when you're ready to do more thorough testing or make available for your end users.

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




View solution in original post

2 REPLIES 2
DW868990
Helper IV
Helper IV

Thanks again, this resolved the issue. Load time thankfully does not seem to be impacted much either!

dm-p
Super User
Super User

Hi @DW868990,

This is hard to solve without knowing anything about your specification or your data, so I can take a stab at it, but if I'm not right, you may need to provide more details about your situation so that we can see if anything else sticks out.

The initial thing that comes to mind is the potential number of rows in your dataset. For performance reasons, Deneb limits queries to 10,000 rows, so if some categories turn up when filtering and then don't for other situations, this might be worth exploring. You can set a property to turn this limit off, and recursively load more data from the model, but please bear in mind that it is (a) dependent on how many rows Power BI decides to give the visual, and (b) the performance of the specification, particularly if you're looking to display a high-number of marks.

Power BI and DAX is generally not great with high-cardinality datasets, so the combination of a + b may be limiting for you. If your visual takes a long time to load the data before its visualised, this is certainly a limitation of the query that Power BI produces, and not something we can change from within a custom visual due to that fact that they cannot specify the DAX to execute (as they are not permitted to know about the data model).

If this does turn out to be your issue, it's not recommended that you have this setting enabled while developing your visual and switch it on when you're ready to do more thorough testing or make available for your end users.

Regards,

Daniel





Did I answer your question? Mark my post as a solution!

Proud to be a Super User!


My course: Introduction to Developing Power BI Visuals


On how to ask a technical question, if you really want an answer (courtesy of SQLBI)




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!

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