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
alexei7's avatar
alexei7
Continued Contributor
8 years ago

Hi nn92,

 

These are measures not filters.

One way you can create them is by right-clicking on the table and selecting "New Measure".

 

If you're able to remove any confidential information and share the model, I'm happy to help create the measures for you.

 

Alex

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?