Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
4 years ago
Solved

How to filter a certain row by a value

Hello!

 

Trying to only show the 67 Days to break even on my chart. The 67 Days is linked to a measure calculated. How do i get the rest of the days to disappear and only show 67 Days to break even? 

  • Hi Anonymous 

     

    You can use the Filter Pane on the left side of the visual.  Expand the filter pane and then have the Y Axis field (the Days) and filter it to TOPN with Top = 1 and then drag the on the ROI Measure as the value, then click apply.

     

     

     

1 Reply

  • TheoC's avatar
    TheoC
    Icon for Community Champion rankCommunity Champion

    Hi Anonymous 

     

    You can use the Filter Pane on the left side of the visual.  Expand the filter pane and then have the Y Axis field (the Days) and filter it to TOPN with Top = 1 and then drag the on the ROI Measure as the value, then click apply.