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

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?