Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Everyone,
I would like to show indicators "co_indic" and "valeur" for differents stores. I would like to filter by section of store colonne "rayon".
My data :
Point de Vente | code_Indicateur | Valeur | Rayon | Tous rayons |
Paris | ACT58960 | 0,8 | Femme | 0 |
Paris | ACT58960 | 0,5 | Homme | 0 |
Paris | ACT58960 | 0,75 | Enfant | 0 |
Paris | ACT58960 | 0,7 | tous rayons | 1 |
Lille | ACT58960 | 0,85 | Femme | 0 |
Lille | ACT58960 | 0,68 | Homme | 0 |
Lille | ACT58960 | 0,2 | Linge de maison | 0 |
Lille | ACT58960 | 0,6 | tous rayons | 1 |
Lyon | ACT58960 | 0,25 | Linge de maison | 1 |
Bordeaux | ACT58960 | 0,3 | Enfant | 1 |
Paris | ACT58963 | 1800 | Femme | 0 |
Paris | ACT58963 | 956 | Homme | 0 |
Paris | ACT58963 | 6943 | Enfant | 0 |
Paris | ACT58963 | 9699 | tous rayons | 1 |
Lille | ACT58963 | 200 | Femme | 0 |
Lille | ACT58963 | 1956 | Homme | 0 |
Lille | ACT58963 | 3943 | Linge de maison | 0 |
Lille | ACT58963 | 6099 | tous rayons | 1 |
Lyon | ACT58963 | 6548 | Linge de maison | 1 |
Bordeaux | ACT58963 | 2365 | Enfant | 1 |
However, I want when "all sections" is selected to display indicators for stores, all departments. My Problem is that a store can only have one section and therefore the "tous rayons" line is that of the section. This line is indicated by the "Tous rayons" column which takes the value 1. How to do so that when I filter on the "tous rayons" value of the "rayon" column, we also display the stores which have only one single section. I have this:
and I would like this:
I have tried Hierachical Filter but it not resolved my problem, cause when I select "Enfant" Bordeaux store doesn't appear :
Thank's for your help.
Solved! Go to Solution.
Hi @lbendlin ,
Thank's for your answer,
I modified your proposal and like that I have no bug when "tous rayons" is selected:
The easiest approach would be to create a disconnected table with the Rayon values, use that to feed the slicer, and then create a measure that checks the SelectedValue ( or FILTERS ) of that slicer's table.
Ref = VALUES(Table2[Rayon])
Note1: I know, there's a bug in the measure if tous rayons is selected together with another range.
Note2: Be aware that the same result can be achieved by clearing the slicer selection, so "tous rayons" is not really required if you can educate your users.
Hi @lbendlin ,
Thank's for your answer,
I modified your proposal and like that I have no bug when "tous rayons" is selected:
User | Count |
---|---|
128 | |
108 | |
99 | |
65 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |