Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It 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 |
---|---|
92 | |
85 | |
77 | |
66 | |
62 |
User | Count |
---|---|
110 | |
95 | |
95 | |
64 | |
59 |