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

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now! Learn more

Reply
Anonymous
Not applicable

Sparklines bar formatting quirk - any way around it?

I have two visuals on a page - one bar chart with weekly marks on x-axis and a simple measure. 

Below that is a table with the same measure in a sparkline. 

 

Works fine at a glance, but when user clicks on one of the weeks in above chart (a single week) - the ENTIRE table containing the sparklines straight disappears. I would expect this to result in the sparkline to only draw one mark, but the whole table disappears, not just the column, not just the mark. 

 

After much fuss, discovered this behavior works as expected with a LINE sparkline, but causes the disappearing table when using BAR sparkline. 

 

Any notes on a workaround (that does not involve "use a line instead of a bar" - obviously). This appears to be a bug - am I right? 

 

Screenshots of before clicking and after clicking demonstrating the issue below. This should be easy for anyone to reproduce. 

 

Before click - line and bar sparklines below main bar chart. 

liverlarson_0-1650327375558.png

click a single week on bar chart: entire table with bar sparklines dissappears (all columns, even the title)

liverlarson_1-1650327451885.png

 

hold CTRL - select any TWO weeks on above chart - everything works as expected:

liverlarson_2-1650327503331.png

 

As an aside, ideally, I would like the sparklines to always show most recent X weeks (I set it to 12) no matter what the crossfiltering is doing. I did write a measure to filter [Shipments] measure, but that does not overcome the disappearing table issue - there is an entirely peripheral set of questions around how to make that act the way I want. 

 

 

 

1 ACCEPTED SOLUTION
Anonymous
Not applicable

Hi  @Anonymous ,

 

Issue has been reported internally(ICM 303219963). Will sync here once there is any update.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

Hello, any updates on this issue ? 

Anonymous
Not applicable

Hi  @Anonymous ,

 

Issue has been reported internally(ICM 303219963). Will sync here once there is any update.

 

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

Helpful resources

Announcements
Power BI DataViz World Championships

Power BI Dataviz World Championships

The Power BI Data Visualization World Championships is back! Get ahead of the game and start preparing now!

November Power BI Update Carousel

Power BI Monthly Update - November 2025

Check out the November 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.