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

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
elabaigt
Frequent Visitor

Non continuous curve

Hello there,

 

I have a problem, I odn't know if it's possible or not can we have an non-continuous curve on a conmbo chart ?

 

I need to know because I have a special state in my data for example if the the stat is A the there is correct data but if it's not an A I have a special value. When I have this result I don't want the last value and the next value connected I want a non-continuous curve.

 

I try to do this curve with this formula :   

ValueState = IF('test_fonction_trou'[state] <> "A"; BLANK(); 'test_fonction_trou'[value])
But this doesn't work I have a continuous curve.
 
Thank you in advance !
2 REPLIES 2
TeigeGao
Solution Sage
Solution Sage

Hi @elabaigt ,

For the conmbo chart, if the value of both visual is blank, it should display an non-continuous x-axis like below:

PBIDesktop_LpWGHDcx81.png

In the above scenario, I used the following DAX query:

Measure = IF(MIN(Table1[Column1]) = "c", BLANK(),MIN(Table1[Column2]))

Best Regards,

Teige

Thank you for your reply @TeigeGao,

 

I tried this DAX query before but I was talking about this type of non continuous line :

courbe non continu.jpg

Can we have this type of curbe in power BI ?

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

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