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

Get certified as a Fabric Data Engineer: Check your eligibility for a 50% exam voucher offer and join us for free live learning sessions to get prepared for Exam DP-700. Get started

Reply
Anonymous
Not applicable

How to show only those dates where all measures make sense?

I have a line and bar combined chart, and the bars are for the full timeline, however the lines are restricted to a shorter period of time. If I add everything to the chart, it is drawn for the full date range, but I only want to show that part where the measures make sense. So instead of this:

Current situationCurrent situation

I want this:

Desired outputDesired output

And of course I would need this to be dynamic, as the range where the measures return a value is affected by a slicer.

 

If I would only use the measures (lines), then I can set that only show values where they are not blank, but it is immediately ruined when the columns are added.

1 REPLY 1
v-xjiin-msft
Solution Sage
Solution Sage

Hi @Anonymous,

 

Could you please share us your pbix file with One Drive or Google Drive if possible? So that we can dig deeper and make some proper tests.

 

Thanks,
Xi Jin.

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! Prices go up Feb. 11th.

Feb2025 Sticker Challenge

Join our Community Sticker Challenge 2025

If you love stickers, then you will definitely want to check out our Community Sticker Challenge!

Jan NL Carousel

Fabric Community Update - January 2025

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