Power BI is turning 10! Tune in for a special live episode on July 24 with behind-the-scenes stories, product evolution highlights, and a sneak peek at what’s in store for the future.
Save the dateEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Hello hello,
I would like to create a visualization that allows me to filter my data according to the column of a table "X" and that acts on my visualizations coming from a table "Y", itself dependent on table "X".
Here are my tables :
Table X, coming from an excel :
Received Date | Done Date | Site |
... | ... | ... |
30/11/2022 | 24/07/2023 | OK |
17/03/2023 | 27/07/2023 | OK |
17/03/2023 | 27/07/2023 | CDS |
15/03/2023 | 24/07/2023 | NOK |
10/03/2023 | 24/07/2023 | CDS |
10/03/2023 | 25/07/2023 | DOR |
... | ... | ... |
Table Y = CALENDAR(DATE(2022,01,01), DATE(2024,01,01))
Date | Received | Done |
... | ... | ... |
30/11/2022 | 1 | |
… | … | … |
10/03/2023 | 2 | |
11/03/2023 | ||
12/03/2023 | ||
13/03/2023 | ||
14/03/2023 | ||
15/03/2023 | 1 | |
16/03/2023 | ||
17/03/2023 | 2 | |
… | … | … |
24/07/2023 | 2 | |
25/07/2023 | 1 | |
26/07/3023 | ||
27/07/2023 | 3 |
And here are my visualizations :
I would like my site visualization filter to apply to my "Received and Done" visualization.
I have already tried adding FILTER or KEEPFILTER or SELECTEDVALUE and other things but have not succeeded.
The best I have found is to add :
FILTER('XI','X'[Site]="OK")
and change "OK" to the site I want, but it is not adapted to my needs.
I have also looked for similar cases on the forum, but have not managed to find a solution.
If anyone has a solution or an idea of what to do, it would be appreciated!
Thank you in advance !
Solved! Go to Solution.
Hi @jdalmass ,
According to your code, I think they are calculated columns. As far as I know, calculated column couldn't be dynamic by slicer
If you want to get dynamic result which is filtered by slicer, I suggest you to create measures.
Done =
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Done Date]),
FILTER('X','X'[Done Date]=MAX('Y'[Date]))))
Received =
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Received Date]),
FILTER('X','X'[Received Date]= MAX('Y'[Date]))))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @jdalmass ,
According to your code, I think they are calculated columns. As far as I know, calculated column couldn't be dynamic by slicer
If you want to get dynamic result which is filtered by slicer, I suggest you to create measures.
Done =
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Done Date]),
FILTER('X','X'[Done Date]=MAX('Y'[Date]))))
Received =
IF(MAX('Y'[Date]) <= TODAY(),
CALCULATE(COUNT('X'[Received Date]),
FILTER('X','X'[Received Date]= MAX('Y'[Date]))))
Result is as below.
Best Regards,
Rico Zhou
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
User | Count |
---|---|
25 | |
11 | |
8 | |
6 | |
6 |
User | Count |
---|---|
27 | |
13 | |
11 | |
9 | |
6 |