Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hi! I have a calculated column "Days To Ship" (a product) with data type "Whole number". Some values here are incorrect for example -34568. Every value has to be at least 1.
I want to create a Gauge:
and I can't use the "Filters" panel.
Can someone please help me? Thank you in advance!
Hi @Mons_Aku ,
You can go to the fields panel, click the 3 dots, and then "edit query". Then you click on the gear icon next to "source".
This will open your table in an edible version, where you can double-click on the entry you want to alternate manually.
All this assuming that you know which are the right values. Alternatively, you can just apply a filter only on the specific visual with data being "greater or equal to" 1.
Let me know if I can support you further.
Best of luck,
Ioannis
Thank you, but as I said I can't use the Filter panel since It's a Gauge visual and nor the Source since It's a calculated column. It doesn't show in Power Query Editor.
@Mons_Aku What is your formula?
For my calculated column?
You can see the incorrect values above.
hi @Mons_Aku
try like,
That was it! Thank you!
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
104 | |
95 | |
80 | |
67 | |
62 |
User | Count |
---|---|
138 | |
107 | |
104 | |
82 | |
63 |