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

How to stop the second y - axis from dropping and showing 0 if there is no data?
01-06-2025
11:09 AM
Hi,
I have a Line and Stacked bar chart. The user can select several years for specific cities, the line follows the years from column to column. However there is currently not data for all years for all cities, so in the case that there is not data, the line drops down to 0 from the previous year value.
I would like to stop it from dropping down to 0 in case there is no data and stop at the previous year value.
Any way to achieve this?
Solved! Go to Solution.
1 ACCEPTED SOLUTION
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2025
12:16 PM
1 REPLY 1
- Mark as New
- Bookmark
- Subscribe
- Mute
- Subscribe to RSS Feed
- Permalink
- Report Inappropriate Content
01-06-2025
12:16 PM

Change your measure to properly return BLANK() if there is no data.

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 - February 2025
Check out the February 2025 Power BI update to learn about new features.

Recommendations
Subject | Author | Posted | |
---|---|---|---|
01-23-2024 02:50 AM | |||
10-07-2022 08:50 AM | |||
12-01-2023 07:26 AM | |||
05-21-2024 03:23 AM | |||
04-15-2024 09:31 AM |
Featured Topics
Top Solution Authors (Last Month)
User | Count |
---|---|
86 | |
76 | |
52 | |
39 | |
35 |
Top Kudoed Authors (Last Month)
User | Count |
---|---|
95 | |
69 | |
55 | |
52 | |
46 |