cancel
Showing results for 
Search instead for 
Did you mean: 
Reply
kalif
Helper I
Helper I

How to reverse the filter Value in same page of Power BI

Dear All Find the below Power BI table & visual page Tables: 1. Date = CALENDAR("1/1/2018", TODAY()) 2. Table 1 S.No BKG_ID FROM TO STATUS 1 IN19010001 CHENNAI BANGALORE CONFRIM 2 IN19010002 CHENNAI BANGALORE CANCEL 3 IN19010003 BANGALORE CHENNAI CONFRIM 4 IN19010004 BANGALORE CHENNAI CONFRIM 5 IN19010005 MUMBAI CHENNAI CONFRIM 6 IN19010006 MUMBAI AHMEDABAD CONFRIM 7 IN19010007 MUMBAI CHENNAI CONFRIM 8 IN19010008 CHENNAI MUMBAI CONFRIM 9 IN19010009 CHENNAI HYDERABAD CONFRIM 10 IN19010010 CHENNAI MADURAI CONFRIM 11 IN19010011 MADURAI CHENNAI CONFRIM 12 IN19010012 MADURAI BANGALORE CONFRIM 13 IN19010013 MADURAI MUMBAI CONFRIM 3. Table 2: DATE BKG_ID VIC_NUM CHR_CODE AMOUNT INV_NUM CHR_TYPE 17-Sep-18 IN19010001 TN05 M 3900 DISE -5000 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 RTO -350 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 TOL -730 E1900501 C 17-Sep-18 IN19010001 TN05 M 3900 FRT 7500 I19000503 R 10-Oct-18 IN19010003 TN05 M 3900 DISE -3000 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 RTO -350 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 TOL -730 E1900504 C 10-Oct-18 IN19010003 TN05 M 3900 FRT 5500 I19000506 R 25-Oct-18 TN05 M 3900 FC -8000 E1900509 C 15-Oct-18 IN19010004 TN05 G 5826 DISE -8000 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 RTO -550 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 TOL -1030 E1900515 C 15-Oct-18 IN19010004 TN05 G 5826 FRT 10500 I19000517 R 17-Oct-18 IN19010011 TN05 G 5826 DISE -3000 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 RTO -350 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 TOL -400 E1900534 C 17-Oct-18 IN19010011 TN05 G 5826 FRT 4500 I19000516 R 25-Oct-18 TN05 G 5826 TRE -2000 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 DISE -8000 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 RTO -550 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 TOL -1030 E1900529 C 21-Oct-18 IN19010005 TN05 G 5826 FRT 10500 I19000530 R 10-Nov-18 IN19010006 TN05 G 5826 DISE -3000 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 RTO -350 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 TOL -400 E1900540 C 10-Nov-18 IN19010006 TN05 G 5826 FRT 4500 I19000546 R 21-Nov-18 TN05 G 5826 TRE -2000 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 DISE -5000 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 RTO -350 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 TOL -730 E1900601 C 15-Nov-18 IN19010007 TN05 M 3900 FRT 7500 I19000602 R 17-Nov-18 IN19010008 TN05 M 3900 DISE -3000 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 RTO -350 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 TOL -730 E1900610 C 17-Nov-18 IN19010008 TN05 M 3900 FRT 5500 I19000606 R 20-Nov-18 TN05 M 3900 SER -3000 E1900609 C 21-Nov-18 IN19010009 TN05 G 5826 DISE -9000 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 RTO -750 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 TOL -1030 E1900700 C 21-Nov-18 IN19010009 TN05 G 5826 FRT 11500 I19000710 R 10-Dec-18 IN19010010 TN05 G 5826 DISE -2500 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 RTO -350 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 TOL -400 E1900708 C 10-Dec-18 IN19010010 TN05 G 5826 FRT 4500 I19000506 R 20-Dec-18 TN05 G 5826 MAIN -2000 E1900401 C 15-Dec-18 IN19010011 TN05 M 3900 DISE -3000 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 RTO -350 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 TOL -430 E1900415 C 15-Dec-18 IN19010011 TN05 M 3900 FRT 5500 I19000425 R 17-Dec-18 IN19010012 TN05 M 3900 DISE -8000 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 RTO -750 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 TOL -1250 E1900435 C 17-Dec-18 IN19010012 TN05 M 3900 FRT 12500 I19000455 R 20-Dec-18 TN05 M 3900 SER -3000 E1900552 C 21-Dec-18 IN19010013 TN05 M 3900 DISE -11000 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 RTO -750 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 TOL -1250 E1900435 C 21-Dec-18 IN19010013 TN05 M 3900 FRT 20500 I19000455 R 25-Dec-18 TN05 M 3900 SER -3000 E1900552 C 4. TABLE 3: Table3 = SUMMARIZE(Table2, Table2[Date1], Table2[BKG_ID],Table2[VIC_NUM],"AMOUNT", SUM(Table2[AMOUNT])) AM GET CORRECT OUTPUT FROM ABOVE TABLE; NEED REVERSE DATE AGAIN SAME FILTER example : From: Bangalore To: Chennai - am get Average Profit - Need reverse like From: Chennai & To is Blank when am select Filter From is Bangalore & To is Chennai
2 REPLIES 2
v-cherch-msft
Microsoft
Microsoft

Hi @kalif

 

It seems you may refer to this post. If it is not your case,Could you provide the sample file?You can upload it to OneDrive and post the link here. Do mask sensitive data before uploading.

 

Regards,

Cherie

 

 

Community Support Team _ Cherie Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
MFelix
Super User
Super User

HI @kalif.

 

The question is not on explicit format please see this post regarding How to Get Your Question Answered Quickly:

https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490 (courtesy of @Greg_Deckler)..

 

Regards,

MFelix


Regards

Miguel Félix


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

Proud to be a Super User!

Check out my blog: Power BI em Português



Helpful resources

Announcements
November 2022 Update

Check it Out!

Click here to read more about the November 2022 updates!

Microsoft 365 Conference â__ December 6-8, 2022

Microsoft 365 Conference - 06-08 December

Join us in Las Vegas to experience community, incredible learning opportunities, and connections that will help grow skills, know-how, and more.

Power BI Dev Camp Session 27

Ted's Dev Camp

This session walks through creating a new Azure AD B2C tenant and configuring it with user flows and custom policies.