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

The Power BI DataViz World Championships are on! With four chances to enter, you could win a spot in the LIVE Grand Finale in Las Vegas. Show off your skills.

Reply
DAMIEN_D_ORAZIO
New Member

Graphic with curves issue

Hello Guys, 

 

I am currently using Power Bi Desktop (january 2022 release ) and I am struggling with the graphic with curves visual. Basically I can't get curves out of my data my goal is to get a curve out of a X axis which will be dates and my Y axis which wil be a percent scale from 0 to 100. The thing is that in my excel sheet I have my dates in column and I think this is the issue so when I add the data I just have points instead of curves but points along the same X whereas my data in the column is different for each date. As I have different visual that interacts with each other thanks to power bi, I would like to get something like this below, when I select a town for instance like Dunkerque.

DAMIEN_D_ORAZIO_0-1677079884845.png

THe data I have looks to something like this :

 

COMMUNES mars-22 avr.-22 mai-22 juin-22 juil.-22 août-22 sept.-22 oct.-22 nov.-22 déc.-22 janv.-23
DUNKERQUE 25.00 33.00 55.00 58.00 75.00 88.00 89.00 92.00 92.00 92.00 92.00
LILLE 26.00 34.00 56.00 59.00 76.00 89.00 89.00 92.00 92.00 92.00 92.00
TOURCOING 27.00 35.00 57.00 60.00 77.00 90.00 89.00 92.00 92.00 92.00 92.00
CALAIS 28.00 36.00 58.00 61.00 78.00 91.00 89.00 92.00 92.00 92.00 92.00
VILLENEUVE-D'ASCQ 29.00 37.00 59.00 62.00 79.00 92.00 89.00 92.00 92.00 92.00 92.00
ARRAS 30.00 38.00 60.00 63.00 80.00 93.00 89.00 92.00 92.00 92.00 92.00
ROUBAIX 31.00 39.00 61.00 64.00 81.00 94.00 89.00 92.00 92.00 92.00 92.00
HAZEBROUCK 32.00 40.00 62.00 65.00 82.00 95.00 89.00 92.00 92.00 92.00 92.00
LENS 33.00 41.00 63.00 66.00 83.00 96.00 89.00 92.00 92.00 92.00 92.00
BAILLEUL 34.00 42.00 64.00 67.00 84.00 97.00 89.00 92.00 92.00 92.00 92.00
DOUAI 35.00 43.00 65.00 68.00 85.00 98.00 89.00 92.00 92.00 92.00 92.00
BERCK 36.00 44.00 66.00 69.00 86.00 99.00 89.00 92.00 92.00 92.00 92.00
LE TOUQUET-PARIS-PLAGE 37.00 45.00 67.00 70.00 87.00 100.00 89.00 92.00 92.00 92.00 92.00
VALENCIENNES 38.00 46.00 68.00 71.00 88.00 100.00 89.00 92.00 92.00 92.00 92.00

 

Sorry for the table but I couldn't manage to paste it properly.

I wonder if anyone could help me out with this, and also if there is a way to hide the data when the result is 0.

Thanks anyway.

 

 

 
0 REPLIES 0

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!

FebPBI_Carousel

Power BI Monthly Update - February 2025

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

Feb2025 NL Carousel

Fabric Community Update - February 2025

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

Top Kudoed Authors