Reply
Topic Options
- Subscribe to RSS Feed
- Mark Topic as New
- Mark Topic as Read
- Float this Topic for Current User
- Bookmark
- Subscribe
- Printer Friendly Page
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Stacked chart - always show zeros
12-23-2022
03:00 AM
Let's say I have a stacked chart that shows two categories. When one category's value is zero it is not shown in the chart. Can I enforce it to show all the time?
Thanks
7 REPLIES 7
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022
03:15 AM
@serpiva64 Ah, I see it now. You are applying it to the Y axis. But for me it is available for X axis.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022
03:09 AM
@serpiva64 I dont see that option. The value is shown as Sum. Is that he reason?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022
03:06 AM
Hi,
have you tried to "show items with no data"?
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022
03:05 AM
You can use a measure like this :
IF(
ISBLANK( [Value] ),0,
[Value]
)
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
12-23-2022
03:33 AM
You can try to replace 0 with a very small value like 0.00001.
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
Helpful resources
Announcements
Join us at the Microsoft Fabric Community Conference
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!
Power BI Monthly Update - January 2025
Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
122 | |
80 | |
47 | |
44 | |
35 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
182 | |
83 | |
70 | |
47 | |
45 |