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

Get Fabric Certified for FREE during Fabric Data Days. Don't miss your chance! Learn more

Reply
EliLyons
New Member

Line chart issue

Hello all, I have noticed that the Line Chart will not display drill through or pop up values once published, if there are no values in the first series in the y-axis.   In my example I have fiscal mth/yr as the x-axis and cumulative totals for Actuals, Budget and Forecast in the y-axis.  If I am looking at fiscal year 2023, where actuals only currently run up through June, but budget and forecast are available for the rest of the year, the visual will not show drill through or pop up values once there are no actuals.

Works fine while designing in desktop.

Has anyone else noticed this behavior or know how to fix?  It did work previously but I am not sure when it may have stopped.

Thanks

3 REPLIES 3
EliLyons
New Member

And I would add if you move DclrdFcstEACRevRunTotal to first in the y-axis, it works properly after published because there is data for series on all periods.

foodd
Super User
Super User

Please provide your work-in-progress Power BI Desktop file (with sensitive information removed) that covers your issue or question completely in a usable format (not as a screenshot).  This will aid members of the Forum in determining the state.

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

This allows members of the Forum to assess the state of the model, report layer, relationships, and any DAX applied.

Below is a link to a simple example of the issue.  The ActRevRunningTotal series is first listed in the y-axis.  Values are only available thru 202309.  FYCalKey is used as the drill through link.  Drill through work perfectly in desktop design mode, but once published to app.high.powerbi.use the list chart stops showing pop-up values and drill through after 202309.  However, the column chart on the bottom works.

https://drive.google.com/drive/folders/1-qmrSbGTosN_s63mvk29EuwCVRtAZ-4i?usp=sharing

 

Helpful resources

Announcements
Fabric Data Days Carousel

Fabric Data Days

Advance your Data & AI career with 50 days of live learning, contests, hands-on challenges, study groups & certifications and more!

October Power BI Update Carousel

Power BI Monthly Update - October 2025

Check out the October 2025 Power BI update to learn about new features.

FabCon Atlanta 2026 carousel

FabCon Atlanta 2026

Join us at FabCon Atlanta, March 16-20, for the ultimate Fabric, Power BI, AI and SQL community-led event. Save $200 with code FABCOMM.