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.
I have slicer on dashboard having options Year,Quarter and Month. On selecting one of this value there is another slicer which will populate respective dates. For example. Slice 1 =Year, Slicer 2 will display all the years present on DB.
Suppose i select quarter 3 of 2018 then following table should display count of sale for each type and last column should display how much sale is more as compaired to previos quarter of 2018.
Like wise if i select Feb in slicer then table should compare data with January.
Any suggestion how to achieve it ?
Type | Sales | vs Q2 |
A | 10 | 12% |
B | 20 | 6% |
C | 30 | -10% |
Solved! Go to Solution.
First Slicer use column Period which display values like Year,Quarter,Month. On selecting one of the value second slicer use Column 'Date Filter'.
On selecting quarter in slicer ,table should display values like follows.
Type | ID | vs Q2 |
K | 10 | 12% |
B | 20 | 6% |
H | 30 | -10% |
Sample Date:
ID | Type | Period | Date Filter |
486957483 P | B | Month | August-2017 |
486957483 C | B | Month | October-2017 |
486957483 G | B | Month | June-2017 |
486957483 M | S | Quarter | Jan to Mar - 2018 |
486957483 J | C | Quarter | Jan to Mar - 2018 |
486957483 J | K | Quarter | Jan to Mar - 2018 |
486957483 M | S | YEAR | 2018 |
486957483 J | C | YEAR | 2018 |
486957483 J | K | YEAR | 2018 |
486957483 J | C | Month | January-2018 |
486957483 E | C | Month | March-2017 |
486957483 H | G | Month | May-2017 |
486957483 L | G | Month | November-2017 |
486957483 A | H | Month | June-2017 |
486957483 J | K | Month | January-2018 |
486957483 C | K | Month | November-2017 |
486957483 W | K | Month | October-2017 |
486957483 C | P | Quarter | Oct to Dec - 2017 |
486957483 C | K | Quarter | Oct to Dec - 2017 |
486957483 N | S | Quarter | Oct to Dec - 2017 |
486957483 R | S | Quarter | Oct to Dec - 2017 |
486957483 W | K | Quarter | Oct to Dec - 2017 |
486957483 C | B | Quarter | Oct to Dec - 2017 |
486957483 T | L | Quarter | Oct to Dec - 2017 |
486957483 L | G | Quarter | Oct to Dec - 2017 |
486957483 K | K | Month | August-2017 |
486957483 T | L | Month | December-2017 |
486957483 N | L | Month | March-2017 |
486957483 P | B | Quarter | Jul to Sep - 2017 |
486957483 K | K | Quarter | Jul to Sep - 2017 |
486957483 A | S | Quarter | Jul to Sep - 2017 |
486957483 C | P | Month | November-2017 |
486957483 N | S | Month | October-2017 |
486957483 M | S | Month | January-2018 |
486957483 G | B | Quarter | Apr to Jun - 2017 |
486957483 H | G | Quarter | Apr to Jun - 2017 |
486957483 A | H | Quarter | Apr to Jun - 2017 |
486957483 R | S | Month | December-2017 |
486957483 A | S | Month | September-2017 |
486957483 N | L | Quarter | Jan to Mar - 2017 |
486957483 E | C | Quarter | Jan to Mar - 2017 |
486957483 N | L | YEAR | 2017 |
486957483 C | P | YEAR | 2017 |
486957483 C | K | YEAR | 2017 |
486957483 G | B | YEAR | 2017 |
486957483 H | G | YEAR | 2017 |
486957483 N | S | YEAR | 2017 |
486957483 R | S | YEAR | 2017 |
486957483 E | C | YEAR | 2017 |
486957483 W | K | YEAR | 2017 |
486957483 P | B | YEAR | 2017 |
486957483 C | B | YEAR | 2017 |
486957483 A | H | YEAR | 2017 |
486957483 K | K | YEAR | 2017 |
486957483 T | L | YEAR | 2017 |
486957483 L | G | YEAR | 2017 |
486957483 A | S | YEAR | 2017 |
Hi @nish2288,
There are several ways to accomplish your desired result. As a starter, please post a sample data.
Proud to be a Super User!
First Slicer use column Period which display values like Year,Quarter,Month. On selecting one of the value second slicer use Column 'Date Filter'.
On selecting quarter in slicer ,table should display values like follows.
Type | ID | vs Q2 |
K | 10 | 12% |
B | 20 | 6% |
H | 30 | -10% |
Sample Date:
ID | Type | Period | Date Filter |
486957483 P | B | Month | August-2017 |
486957483 C | B | Month | October-2017 |
486957483 G | B | Month | June-2017 |
486957483 M | S | Quarter | Jan to Mar - 2018 |
486957483 J | C | Quarter | Jan to Mar - 2018 |
486957483 J | K | Quarter | Jan to Mar - 2018 |
486957483 M | S | YEAR | 2018 |
486957483 J | C | YEAR | 2018 |
486957483 J | K | YEAR | 2018 |
486957483 J | C | Month | January-2018 |
486957483 E | C | Month | March-2017 |
486957483 H | G | Month | May-2017 |
486957483 L | G | Month | November-2017 |
486957483 A | H | Month | June-2017 |
486957483 J | K | Month | January-2018 |
486957483 C | K | Month | November-2017 |
486957483 W | K | Month | October-2017 |
486957483 C | P | Quarter | Oct to Dec - 2017 |
486957483 C | K | Quarter | Oct to Dec - 2017 |
486957483 N | S | Quarter | Oct to Dec - 2017 |
486957483 R | S | Quarter | Oct to Dec - 2017 |
486957483 W | K | Quarter | Oct to Dec - 2017 |
486957483 C | B | Quarter | Oct to Dec - 2017 |
486957483 T | L | Quarter | Oct to Dec - 2017 |
486957483 L | G | Quarter | Oct to Dec - 2017 |
486957483 K | K | Month | August-2017 |
486957483 T | L | Month | December-2017 |
486957483 N | L | Month | March-2017 |
486957483 P | B | Quarter | Jul to Sep - 2017 |
486957483 K | K | Quarter | Jul to Sep - 2017 |
486957483 A | S | Quarter | Jul to Sep - 2017 |
486957483 C | P | Month | November-2017 |
486957483 N | S | Month | October-2017 |
486957483 M | S | Month | January-2018 |
486957483 G | B | Quarter | Apr to Jun - 2017 |
486957483 H | G | Quarter | Apr to Jun - 2017 |
486957483 A | H | Quarter | Apr to Jun - 2017 |
486957483 R | S | Month | December-2017 |
486957483 A | S | Month | September-2017 |
486957483 N | L | Quarter | Jan to Mar - 2017 |
486957483 E | C | Quarter | Jan to Mar - 2017 |
486957483 N | L | YEAR | 2017 |
486957483 C | P | YEAR | 2017 |
486957483 C | K | YEAR | 2017 |
486957483 G | B | YEAR | 2017 |
486957483 H | G | YEAR | 2017 |
486957483 N | S | YEAR | 2017 |
486957483 R | S | YEAR | 2017 |
486957483 E | C | YEAR | 2017 |
486957483 W | K | YEAR | 2017 |
486957483 P | B | YEAR | 2017 |
486957483 C | B | YEAR | 2017 |
486957483 A | H | YEAR | 2017 |
486957483 K | K | YEAR | 2017 |
486957483 T | L | YEAR | 2017 |
486957483 L | G | YEAR | 2017 |
486957483 A | S | YEAR | 2017 |
User | Count |
---|---|
89 | |
73 | |
69 | |
65 | |
56 |
User | Count |
---|---|
97 | |
92 | |
85 | |
74 | |
68 |