Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

how to keep axis range when filtering graphs

Hi,  I have a graph showing age (x) and number of people (y). I have another graph on the same page, where I can select a group of people that gets highlited on the first graph.  However it is hard...
Need Help
  • v-kkf-msft's avatar
    v-kkf-msft
    4 years ago

    Hi Anonymous ,

     

    Please create these two measures and set them to the minimum and maximum values of the X-axis respectively.

     

    Min_X = MINX ( ALL ( 'Table' ), 'Table'[age] )
    Max_X = MAXX ( ALL ( 'Table' ), 'Table'[age] )

     

    If the problem is still not resolved, please provide detailed error information or the expected result you expect. Let me know immediately, looking forward to your reply.
    Best Regards,
    Winniz
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

     

speedramps's avatar
speedramps
Icon for Super User rankSuper User
4 years ago

Create just one graph

with  age (x) and number of people (y) and  legend = group.

then you can compare groups  A,B, C, D, E on a line or stack graph.

 

Also add slicer = group with multipole selecrtion turned on.

the the user can pick and choose which groups they want to compare.  eg just A, C and E

 

I have helped you, now please help me by giving kudos.

Click the thumbs up and accept as solution button. 

One question per ticket please. If you need to extend your request then please raise a new ticket.

You will get a quicker response and each solver will get the kudos they deserve. Thank you ! 😎