Forum Discussion

nn92's avatar
nn92
Frequent Visitor
8 years ago

plot multiple lines with different data filters on one graph

Hi,   I would like to plot multiple line on one graph, but I can't do it with simple "line chart".   I have only one dataset, and what I want to do is to use lines to represent different filters....
Need Help
Show and Tell
nn92's avatar
nn92
Frequent Visitor
8 years ago

alexei7  maybe this could help?

 

Problem is that my dataset is few GBs, so the model has 200mb and I cant upload it so easily.

 

Maybe this could help:

Axis = lead_time

Legent = RESERVATION_CASE_DESC

Values = Count of RESERVATION_CASE_DESC

Filters = ADEP is LEMD    ***this is the one I want to vary for different lines

              RESERVATION_CASE_DESC is True Revision

 

Table name is "TRP-visual"

 

Is this enough to write measure in the code? It takes a lot of space so I cant upload, sorry...

alexei7's avatar
alexei7
Continued Contributor
8 years ago

nn92 - we may have to give up after this, it's quite hard to do this remotely!

 

Give this a go and see if this works as a measure for LEMB to put in your graph.

 

LEMB = CALCULATE(count('TRP-visual'[RESERVATION_CASE_DESC]),FILTER('TRP-visual',''TRP-visual'[ADEP]="LEMB"))

If it works, you should be able to adapt it for other values.


Good luck,

Alex

  • nn92's avatar
    nn92
    Frequent Visitor
    8 years ago

    alexei7

    Many thanks for the proposed solution! 

    I created a new measure and it is now on the list with all the columns. But I tried to drag&drop it, and there was nothing new displayed.. Am I doing something wrong?