Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
Hi Dax is new for Me. I just want to use slicer (ID name) to filter the Doc No. but the same time, I don't want to filter ID Name in Table. Date Doc No_ ID ID Name Amount 04-04-2018 1 AA Joe 100 04-04-2018 1 BB Joe 200 24-09-2018 2 AA Joe 300 24-09-2018 2 CC Mark 400 25-09-2018 3 AA Mark 500 25-09-2018 3 BB Mark 600 When I prepare the dashboard using slicer (ID name) it doesn't show the ID (CC) and it also filtered from slicer (ID) along with Doc no.. Any idea to exclude the ID (CC) from slicer (ID name) Date Doc No_ ID Total 04-04-2018 1 AA 100 04-04-2018 1 BB 200 24-09-2018 2 AA 300 Grand Total 600 Is it any way to get the below result? Please help me it is urgent. I m trying from last three days and don’t succeed. Date Doc No_ ID Total 43194 1 AA 100 43194 1 BB 200 43367 2 AA 300 43367 2 CC 400 Grand Total 1000
Hi @AadiSingh_2018,
Can you please are your pbix power bi file so that I can help you on this problem
Regards
Affan
dear Affan,
I m new in this form and don't know how to add the file. I have excel file
Please advise how to do this but please note that i have millons of rows of Doc no. and also hundred of rows of ID name
whenever you apply the filter on ID Name it won't effect the table . This is you requirement correct ?
If Yes, follow the below steps
1. Click the ID Name filter
2. Go to the Format ribbon on top menu
3. Click the Edit Interaction button
4. Click the None icon on the Table. So the matter here we stop the ID Name interaction the table.
Dear Baskar
Thanks for your vaulable Time, i m using dax for POwer pivot not for Power BI and second I want to apply filter Doc No column (Document Number) in table but exlcude the filter on ID column in same table. is there any way, using index coloum for adding new table or any??
Dear Baskar, No it is not working, I used your formula but the result is same. Date Doc No ID Total 43194 1 AA 300 43194 1 BB 300 43367 2 AA 700
it is not showing the ID (CC) in ID column
Still Awaiting for help!!!
Your requirement is not clear, what is ID Name slicer here.
Can you please attach sample images from your PBI file.
ID name is Name mentioned in Table
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
88 | |
86 | |
83 | |
65 | |
49 |
User | Count |
---|---|
127 | |
108 | |
88 | |
70 | |
66 |