Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi all,
I setup a slicer to dinamically change the values in the tiles based upon the selection there, using the code below:
Selection KPI =
Switch (True (),
Selectedvalue ('KPI Table'[KPI]) = "Case Fill %", [Case Fill %],
Selectedvalue ('KPI Table'[KPI]) = "Unit Fill Rate %", [Unit Fill Rate %],
Selectedvalue ('KPI Table'[KPI]) = "Supply Perfect Orders %", [Supply Perfect Orders %],
Selectedvalue ('KPI Table'[KPI]) = "Perfect Orders %", [Perfect Orders %],
Selectedvalue ('KPI Table'[KPI]) = "Delivery on Time (Order)", [Delivery on Time (Order)],
Selectedvalue ('KPI Table'[KPI]) = "Delivery on Time (Line)", [Delivery on Time (Line)],
Selectedvalue ('KPI Table'[KPI]) = "Delivery Perfect Order", [Delivery Perfect Order %],
Blank())
When I tried to use FORMAT to have the number in percent I am gettig the BLANK results
Selection KPI =
Switch (True (),
Selectedvalue ('KPI Table'[KPI]) = "Case Fill %", FORMAT([Case Fill %],"0%"),
Selectedvalue ('KPI Table'[KPI]) = "Unit Fill Rate %", FORMAT[Unit Fill Rate %],"0%")
Selectedvalue ('KPI Table'[KPI]) = "Supply Perfect Orders %", FORMAT[Supply Perfect Orders %],"0%")
Selectedvalue ('KPI Table'[KPI]) = "Perfect Orders %", FORMAT[Perfect Orders %],"0%")
Selectedvalue ('KPI Table'[KPI]) = "Delivery on Time (Order)", [Delivery on Time (Order)],
Selectedvalue ('KPI Table'[KPI]) = "Delivery on Time (Line)", [Delivery on Time (Line)],
Selectedvalue ('KPI Table'[KPI]) = "Delivery Perfect Order", FORMAT([Delivery Perfect Order %],"0%")
Blank())
Any ideas how I can fix that?
Cheers,
Gilly
Solved! Go to Solution.
Hi @v-lid-msft ,
Just realized that the issue was with the tile (Sparkline By Okviz) that I was using, have changed the starndard one and it working now.
Hi @Anonymous ,
We found there are some syntax error in your formula, could you please try the following formula?
Selection KPI = SWITCH ( TRUE (), SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Case Fill %", FORMAT ( [Case Fill %], "0%" ), SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Unit Fill Rate %", FORMAT ( [Unit Fill Rate %], "0%" ), SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Supply Perfect Orders %", FORMAT ( [Supply Perfect Orders %], "0%" ), SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Perfect Orders %", FORMAT ( [Perfect Orders %], "0%" ), SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Delivery on Time (Order)", [Delivery on Time (Order)], SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Delivery on Time (Line)", [Delivery on Time (Line)], SELECTEDVALUE ( 'KPI Table'[KPI] ) = "Delivery Perfect Order", FORMAT ( [Delivery Perfect Order %], "0%" ), BLANK () )
Best regards,
Community Support Team _ Dong Li
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-lid-msft ,
Just realized that the issue was with the tile (Sparkline By Okviz) that I was using, have changed the starndard one and it working now.
User | Count |
---|---|
125 | |
106 | |
99 | |
63 | |
60 |
User | Count |
---|---|
135 | |
116 | |
101 | |
71 | |
61 |