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 seen a lots of topics talking about it, but every time, it was about creating new tables or calculated columns ; I cannot.
I use DirectQuery mode, and I want to have a pie chart with Top 5 turnover and "Others" category represented.
I hope to have not missed the right topic, but here is this one.
I already have a rank measure which ranks the cities by turnover.
Thank you.
Try below measure,
Thank you for your answer @Anonymous.
Will it gives me the "others" category?
share your sample dataset.
sorry it will not show others. let me try for others
I can't add an attachment to the message.
But here is some data:
Country | Turnover |
USA | 100 |
CANADA | 200 |
AUSTRALIA | 300 |
GERMANY | 100 |
RUSSIA | 500 |
LITHUANIA | 600 |
UKRAINE | 400 |
The result should be:
without column in not possible. you need to create calculated column.
Ok so no solution for me 😔 as I cannot create calculated columns.
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 |
---|---|
41 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
44 | |
32 | |
30 | |
18 | |
17 |