Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Enhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.

Reply
Anonymous
Not applicable

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? Capture.JPGCapture1.JPG

1 ACCEPTED SOLUTION
TheoC
Super User
Super User

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.

 

TheoC_1-1644290334352.png

 

 

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

1 REPLY 1
TheoC
Super User
Super User

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.

 

TheoC_1-1644290334352.png

 

 

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

Helpful resources

Announcements
July 2025 community update carousel

Fabric Community Update - July 2025

Find out what's new and trending in the Fabric community.

July PBI25 Carousel

Power BI Monthly Update - July 2025

Check out the July 2025 Power BI update to learn about new features.

Join our Fabric User Panel

Join our Fabric User Panel

This is your chance to engage directly with the engineering team behind Fabric and Power BI. Share your experiences and shape the future.