Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi
Am looking for help on dynamic report changes (Power Pivot) based on Slice Selection.
Scenario :
Fact data table is Flat mode ( not tabulated/ and cannot restructure) hence in data model had to create table for the ZONE ( Data mode screen)
What is Required,
based on user slicer Selection of "Area" and "Region" the report view to change for Zone for based on criteria
Link of the model https://1drv.ms/x/s!ArfkmPx6DIXHake1H54OkIxmA4A
Through calcuate function
1. =IF([Zone]="AAA",CALCULATE(sum(fTable[QTY]),FILTER('fTable',fTable[AAA]>=0&&fTable[AAA]<=2)),BLANK())
2. =IF([Zone]="BBB",CALCULATE(sum(fTable[QTY]),FILTER('fTable',fTable[BBB]>=0&&fTable[BBB]<=2)),BLANK())
3. Sum area =CALCULATE(sum(fTable[QTY]),'dArea')
Type | Area | Region | QTY | AAA | BBB | CCC | DDD |
A | FG | V1 | 10 | 2 | 0 | 2 | 2 |
A | FG | V1 | 10 | 2 | 0 | 2 | 1 |
A | FG | V2 | 10 | 0 | 0 | 1 | 1 |
A | TF | V1 | 10 | 0 | 2 | 2 | 1 |
A | TF | V1 | 10 | 3 | 1 | 2 | 1 |
A | TF | V1 | 10 | 2 | 1 | 1 | 2 |
A | RG | V2 | 10 | 0 | 1 | 1 | 1 |
A | RG | V1 | 10 | 0 | 2 | 3 | 1 |
A | RG | V2 | 10 | 2 | 1 | 1 | 1 |
A | KG | V2 | 10 | 1 | 1 | 1 | 1 |
A | KG | V2 | 10 | 2 | 2 | 1 | 1 |
A | KG | V2 | 10 | 1 | 1 | 1 | 1 |
Solved! Go to Solution.
It seems that you may select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
It seems that you may select Unpivot Columns in Query Editor first.
https://community.powerbi.com/t5/Desktop/matrix-to-table-help/td-p/329415
User | Count |
---|---|
141 | |
113 | |
104 | |
78 | |
64 |
User | Count |
---|---|
136 | |
125 | |
107 | |
70 | |
61 |