Forum Discussion

elabaigt's avatar
elabaigt
Frequent Visitor
7 years ago

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 !
Need Help

2 Replies

  • TeigeGao's avatar
    TeigeGao
    Solution Sage
    7 years ago

    Hi elabaigt ,

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

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

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

    Best Regards,

    Teige

    • elabaigt's avatar
      elabaigt
      Frequent Visitor
      7 years ago

      Thank you for your reply TeigeGao,

       

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

      Can we have this type of curbe in power BI ?