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

Grow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.

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
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel1

Power BI Monthly Update - May 2024

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