cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
Frequent Visitor

FILTER TABLE BASED ON SELECTED VALUE

Dear All,

I have this situation. In one table i have costs and revenues for each order/job:

OrderNType CostsDate_operationsValues
1Revenue 1000
1Cost101-05-2020-300
1Cost2 -200
1Cost3 -100
2Revenue 1000
2Cost103-05-2020-300
2Cost2 -200
2Cost3 -100
3Revenue 1000
3Cost103-05-2020-300
3Cost2 -200
3Cost3 -100

 

I gave the opportunity to filter a report based on Date_Operation, so that we can obtain what we have done in one day. I need to show instead in one visual, keeping the selected date filter, to show all the order and all the lines that includes the selected job.

For example I have selected the date '03/05/2020' and i wish to see in the a table this result (all the lines orders of the selected date). 

2Revenue 1000
2Cost103/05/2020-300
2Cost2 -200
2Cost3 -100
3Revenue 1000
3Cost103/05/2020-300
3Cost2 -200
3Cost3 -100

thanks for help.

4 REPLIES 4
Super User III
Super User III

@Todi79 ,

 

Another approach would be fix the date value on columns: 

Capture.PNG

Did I answer your question? Mark my post as a solution!
Ricardo

 



Did I answer your question? Mark my post as a solution!

Proud to be a Super User!



Super User IV
Super User IV

Here is another example.


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




Super User IV
Super User IV

You need a complex selector like what I have attached. It is based on the concept of the Inverse Selector. Basically, you need to filter your table by date. Then you need to get a distinct list of your order id's. Your selector would check if a row's order id is IN the list.

 

https://community.powerbi.com/t5/Quick-Measures-Gallery/Inverse-Selector/m-p/648290#M325

 

 


---------------------------------------

@ me in replies or I'll lose your thread!!!

I have a NEW book! 
DAX Cookbook from Packt
Over 120 DAX Recipes!




Did I answer your question? Mark my post as a solution!

Proud to be a Super User!




@Greg_Deckler , Thank you for the solution. I am working on something similar, but I need a little more help from you. Instead of showing the last 4 weeks in the selection, can we show the current week, last week & same week last month (3 columns)? 

Helpful resources

Announcements
secondImage

Congratulations!

We are excited to announce the Power BI Super Users!

Wave Release 2

Check out the updates in Power BI.

Overview of Power BI 2020 release wave 2!

Microsoft Ignite

Microsoft Ignite

Join digitally, March 2–4, 2021 to explore new tech that's ready to implement. Experience the keynote in mixed reality through AltspaceVR!

secondImage

The largest Power BI virtual conference

100+ sessions, 100+ speakers, Product managers, MVPs, and experts. All about Power BI. Attend online or watch the recordings.