Solved: How to filter a certain row by a value

Anonymous · ‎02-07-2022

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?

TheoC · ‎02-07-2022

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.

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias

View solution in original post

TheoC · ‎02-07-2022

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.

If I have posted a response that resolves your question, please accept it as a solution to formally close the post.

Also, if you are as passionate about Power BI, DAX and data as I am, please feel free to reach out if you have any questions, queries, or if you simply want to connect and talk to another data geek!

Want to connect?www.linkedin.com/in/theoconias