Forum Discussion

frankiekho's avatar
frankiekho
Icon for Helper I rankHelper I
2 years ago

Line Chart - After Filter, does not affect the main Line

Hi,   as you can see from my screenshot, i have a line chart showing activities that happens in each dot. some dots contain several activities, some have only one activitiy.   and i have a vertic...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
2 years ago

frankiekho , Create two lines. Enable the marker on one and set the line width to 0 for that line.

 

The second line without markers removes the filter status description

 

Assume you using measure M1

M2 = calculate([M1], removefilters(Table[status_description]))  // for only line 

  • frankiekho's avatar
    frankiekho
    Icon for Helper I rankHelper I
    2 years ago

    hi amitchandak , thanks for your quick reply. i have created M2, but it couldn't be placed in the "second y-axis" field slot.