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

Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!

Reply
aortuno
Frequent Visitor

Always show the same x-axis values in the same order.

I'm putting together a dashboard that has two bar charts, they each display different measures for the same items.


Item A, Item 2 and Item 3.

 

Some days I refresh the data and whichever Item has a value of zero disappears from the X axis.

 

What I want is for the bar chart to always show the same values in the x-axis in the same order, even if sometimes some of them are zero and display no bar. 


Is that possible? 


Thanks!

1 ACCEPTED SOLUTION
RMDNA
Solution Sage
Solution Sage

@aortuno,

 

In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.

 

x.PNG

View solution in original post

2 REPLIES 2
RMDNA
Solution Sage
Solution Sage

@aortuno,

 

In the field options on your chart, select your axis and check "Show items with no data." That should give you what you need.

 

x.PNG

aortuno
Frequent Visitor

Thanks that did it.

Helpful resources

Announcements
April AMA free

Microsoft Fabric AMA Livestream

Join us Tuesday, April 09, 9:00 – 10:00 AM PST for a live, expert-led Q&A session on all things Microsoft Fabric!

March Fabric Community Update

Fabric Community Update - March 2024

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