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

Hi, alexei7 ,

thanks for trying to help!

 

I posted bigger screenshot, with more info. Could you please tell me where exactly I need to type in this filter, and where to create new line (if it is under tabel->edit query...) or something ele?

 

THanks in advance!

 

 

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

  • 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  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...

  • 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?