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

Get certified in Microsoft Fabric—for free! For a limited time, the Microsoft Fabric Community team will be offering free DP-600 exam vouchers. Prepare now

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
OCT PBI Update Carousel

Power BI Monthly Update - October 2024

Check out the October 2024 Power BI update to learn about new features.

September Hackathon Carousel

Microsoft Fabric & AI Learning Hackathon

Learn from experts, get hands-on experience, and win awesome prizes.

October NL Carousel

Fabric Community Update - October 2024

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