Forum Discussion

SebastianLM's avatar
SebastianLM
Helper I
8 years ago
Solved

Discrete line chart

Hey guys,

 

I'd like to know if there is a way to show a discrete line chart by axis and not only by values, I mean something similar to what Tableau does:

 

Tableau:


Power BI:

 

If you see the yellow highlighted line is not a real increment, it is just a change in one of the X axis: "DROGUERIAS ATLANTICO" to "DROGUERIAS C/MARCA".

 

I need to hide this comunication line and leave it like Tableau is showing the data and if we could put a line between them would be great!

 

Thanks in advanced! 

  • Hello Anonymous, I already have the latest release but still seems to allow more than one value only if you don't add a legend. Anyway I "solve" this adding NULL values in the dataset and telling the visual to show data with no values in the measure. Hope this feature get implemented soon, is pretty usefull. 

     

    Thanks for all the support guys!

     

    :smileyvery-happy:

8 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    SebastianLM  you have to create 2 seperate charts for this. Power BI does not do this similar to Tableau unfortunately.

    • SebastianLM's avatar
      SebastianLM
      Helper I

      But the problem here is that sometimes it has more than 2 values. Well if this is not possible I think I'd need to find a workarround using R. Once I got it I'll post it here.

       

      Thanks anyway.

      • v-yulgu-msft's avatar
        v-yulgu-msft
        Microsoft Employee

        Hi SebastianLM,

         

        Maybe you can create two separate measures, one for DROGUERIAS ATLANTICO and another for DROGUERIAS C/MARCA.

         

        Regards,

        Yuliana Gu

  • Anonymous's avatar
    Anonymous
    Not applicable

    SebastianLM This feature is now in the August release, you should try updating PowerBI and try making it now.

    • SebastianLM's avatar
      SebastianLM
      Helper I

      Hello Anonymous, I already have the latest release but still seems to allow more than one value only if you don't add a legend. Anyway I "solve" this adding NULL values in the dataset and telling the visual to show data with no values in the measure. Hope this feature get implemented soon, is pretty usefull. 

       

      Thanks for all the support guys!

       

      :smileyvery-happy:

  • Hi SebastianLM ,

     

    I seem to have missed the party.

    Line chart x-axes do now support both linear as categorical values. 🙂