Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more.
Get startedGrow your Fabric skills and prepare for the DP-600 certification exam by completing the latest Microsoft Fabric challenge.
Hi experts,
I have a problem because in my report I have two matrix that shows amounts, the first matrix has a summary and the other matrix show the detail by accounts.
When I select 1 row in the first matrix I need to show the details in the second matrix. that works perfectly.
The issue is when I select one account in the second matrix, immediately it loses the filter of the first matrix and shows all accounts, (I tried changing the iteration to NONE but nothing happen)
I need that the information in the first and second matrix remains unchanged because I am showing totals in some Cards and in a hidden panel the details of each account.
Can you please help me?
This is how the tables are related:
These are the tables I am using:
Summary:
Expense Category | Type | Amount |
01- Restaurant Crew | a) Crew Payroll | 690465.65 |
01- Restaurant Crew | b) Crew Benefits | 16048.89 |
01- Restaurant Crew | c) Crew Medical and Claims | 70853.95 |
01- Restaurant Crew | d) CAM Expenses | 113393.78 |
01- Restaurant Crew | e) Other Crew Expenses | 6326.14 |
02- Fuel Expense | a) Fuel Expense | 2255029.44 |
03- Kitchen expenses | a) Fixed Docking & Other | 120603.82 |
03- Kitchen expenses | b) Maintenance | 398165.33 |
03- Kitchen expenses | c) Utilities & Other | 5839.65 |
04- Maint.,Consumables, & Dryd | a) Consumables | 133957.26 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | 403296.7 |
04- Maint.,Consumables, & Dryd | c) Docking Expenses | 47599.22 |
04- Maint.,Consumables, & Dryd | e) Damage Expense | 0 |
05- Other Restaurant | a) Telephone Expense | 7369.09 |
05- Other Restaurant | b) Freight | 37211.33 |
05- Other Restaurant | c) Miscellaneous | 101057.45 |
details:
Expense Category | Type | Restaurant | OBJ_DESCRIPTION | AccountNbr | DESCRIPTION | Amount |
03- Kitchen expenses | b) Stevedoring | Miami | Travel | XXXX00061131019 | Nassau, Bahamas | 500 |
03- Kitchen expenses | b) Stevedoring | Miami | Travel | XXXX00061131044 | Port Canaveral | -563.65 |
03- Kitchen expenses | b) Stevedoring | Miami | Travel | XXXX00061131068 | Bayonne, NJ | 398228.98 |
02- Fuel Expense | a) Fuel Expense | Miami | Bunker Swaps | YYY6123 | Bunker Swaps | -421702.48 |
02- Fuel Expense | a) Fuel Expense | Miami | Bunkering | XXXX00061211100 | Bunker - IFO | 2394579.4 |
02- Fuel Expense | a) Fuel Expense | Miami | Bunkering | XXXX00061211200 | Bunker - MGO | 219696.29 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Cleaning Supplies | 3334017201 | Cleaning Supplies | 73.5 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Cleaning Supplies | 3334027201 | Cleaning Supplies | 343.7 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Cleaning Supplies | 3334107201 | Cleaning Supplies | 197.66 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40162033930 | Office Materials Crunchtime | 642.46 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033000 | Nautical Stores | 4008.63 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033300 | Pollution ctrl/pers sfty Eq | 12061.32 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033400 | Tools & Instruments | 9559.13 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033600 | Painting Equipment | 6298.5 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033700 | Cleaning Material & Equip. | 5510 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033800 | Lube Oil & Lubricants | 42704.18 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033810 | Chemical Additives | 10332.95 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033910 | Welding Materials | 17611.05 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033960 | Pipe & Pipe Fittings | 11968.55 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | Consumable Stores | XXXX40262033970 | Steel,Metals and Fasteners | 11316.24 |
04- Maint.,Consumables, & Dryd | c) Docking Expenses | Miami | Docking Expenses | XXXX40262055009 | DD Amortization | 47599.22 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044118 | PAX Freight/Service Elev. | 1014.79 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044153 | Refrgs, Walkin boxes& Ice Mach | 6257.71 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044180 | Office and Engraving Equipment | 348.09 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044200 | Lifting and Transport | 1032.43 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044310 | FW Generators incl Pumps | 24357.71 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044320 | Steer. Gear,Thrusters &Stabil. | 955.79 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044330 | Sewage, Garb. Hndlg & Inciner. | 12967.32 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044350 | Air Conditioning Equipment | 1758.94 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044890 | Common electric spares | 3839.2 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044930 | Common Engine Spares | 2196.48 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40262044935 | Common Refrg. Spares | 7153 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044100 | Laundry Equipment | 14413.38 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044101 | Galley Equipment | 13450.37 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044102 | Dishwashers | 9430.34 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044103 | Sanitary Equipment | 4627.45 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044104 | Water Features and Attractions | 1905.69 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044105 | Lighting | 13403.47 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044106 | Hotel Maintenance Misc. | 25994.69 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044107 | Flooring | 4245.4 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044110 | Furniture and Fixtures | 8154.1 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40662044112 | Refurbishment Misc. | 6297.34 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40962044000 | Hull & Superstructure | 737.5 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40962044400 | Comm & Navig Equipment | 4398.16 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40962044455 | Closed circuit TV surveillance | 10990.04 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40962044500 | Engines | 14046.84 |
04- Maint.,Consumables, & Dryd | b) Spare Parts-R&M/Refurbishme | Miami | Engines | XXXX40962044580 | Reduct. Gear Shafts&Prop | 24658.06 |
05- Other Restaurant | a) Telephone Expense | Miami | Freight In | XXXX40262099000 | Telephone Expense | 7369.09 |
05- Other Restaurant | b) Freight | Miami | Freight In | XXXX40262099200 | Freight In | 25243.52 |
05- Other Restaurant | b) Freight | Miami | Freight In | XXXX40262099202 | Destination Fees | 73.85 |
05- Other Restaurant | b) Freight | Miami | Freight In | XXXX40262099203 | Air Freight/Special Transp. | 1371.05 |
05- Other Restaurant | b) Freight | Miami | Freight In | XXXX40262099204 | Freight -Landed Goods Advise | 1444.8 |
05- Other Restaurant | b) Freight | Miami | Freight In | XXXX40662099290 | Misc. Freight Expense | 9078.11 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099921 | Det Norske Veritas | 29503.78 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099930 | Waste Related Taxes | 1641.55 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099990 | Miscellaneous | -949.22 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099991 | Hazardous & Other Reg. Waste | 36246.13 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099994 | Bilge Water | 4410 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099995 | Sludge Removal | 29281.53 |
05- Other Restaurant | c) Miscellaneous | Miami | Freight In | XXXX40262099997 | Grey Water Removal | 923.68 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | General Supplies | 3334017203 | General Supplies | 200.58 |
04- Maint.,Consumables, & Dryd | a) Consumables | Miami | General Supplies | 3334027203 | General Supplies | 33.29 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Harbor Maintenance Tax | YYY6115 | Harbor Maintenance Tax | 5822.24 |
02- Fuel Expense | a) Fuel Expense | Miami | Misc Fuel | XXXX00061221000 | Fuel Additives | 62456.23 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111002 | Labadee | 1324.98 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111008 | St Maarten | 23136.39 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111009 | Antigua | 6236.04 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111012 | St Kitts | 2833.33 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111019 | Nassau | 7626.5 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111023 | St Lucia | 3252.77 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111044 | Port Canaveral | 59330.89 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111068 | Bayonne, NJ | 98919.94 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111177 | Perfect Day at Cococay, Bahama | 336.64 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111264 | Glasgow (Greenock), Scotland | -309.28 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111270 | Southampton, England | -59514.79 |
03- Kitchen expenses | a) Fixed Docking & Other | Miami | Norfolk, VA | XXXX00061111294 | Belfast, Ireland | -28391.83 |
03- Kitchen expenses | c) Utilities & Other | Miami | Other Kitchen expenses | YYY6132 | Other Kitchen expenses | 5839.65 |
Solved! Go to Solution.
@gomezc73 , When you click on the second it usually cleans up filter and apply its own filter. The slicer can retain value, visual do not.
But Try CTRL+click and check
@gomezc73 , When you click on the second it usually cleans up filter and apply its own filter. The slicer can retain value, visual do not.
But Try CTRL+click and check
Hi worked perfectly using Control+Click, thank you.
PBI doesn't have a trick to allow this using only Click?
User | Count |
---|---|
89 | |
88 | |
75 | |
67 | |
58 |
User | Count |
---|---|
137 | |
110 | |
91 | |
84 | |
69 |