Discrete line chart

[SebastianLM]

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! 

[lousegers]

Hi @SebastianLM ,

I seem to have missed the party.

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

[Anonymous]

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

[SebastianLM · Accepted solution]

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!

[Anonymous]

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

[SebastianLM]

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]

Hi @SebastianLM,

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

Regards,

Yuliana Gu

[SebastianLM]

Hi again @v-yulgu-msft,

I tried to manually create one especific measure for each value in MERCADO (the filed that contains DROGUERIAS  ETC), but now I only can add them in the visual if I don't use a legend, this is frustrating, do you know any workaround for this? I mean a line chart with multiple values and using legends as well

[SebastianLM]

Well, as I said  before, there are more than ATLANTICO and C/MARCA, and it is not usable to create a different viz to each value, but thanks anyways.

In fact if someone know the correct way to do it with an R viz I'll apreciate it, or if ther is an special R forum to discuss this, please let me know.