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.
Hello All,
I have created Age bucket as a measure- which is dynamically calculating bucket based on the selected year in slicer.
Now I have a requirement to do the following:
I would like to create a graph with Age Bucket and # of employees.
I want to plot Age bucket measure on X- axis and Total count of employees on Y axis. – But remember we have Age Bucket as measure not a column. I do not want to use calculated column for bucket.
example: How many employees was in each Age Bucket in 2018?
Any help would be appreciated.
Thanks.
Sonu
@sonuojha1 you cannot use measure on x-axis, you have convert bucket into column.
I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos whoever helped to solve your problem. It is a token of appreciation!
⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡
Subscribe to the @PowerBIHowTo YT channel for an upcoming video on List and Record functions in Power Query!!
Learn Power BI and Fabric - subscribe to our YT channel - Click here: @PowerBIHowTo
If my solution proved useful, I'd be delighted to receive Kudos. When you put effort into asking a question, it's equally thoughtful to acknowledge and give Kudos to the individual who helped you solve the problem. It's a small gesture that shows appreciation and encouragement! ❤
Did I answer your question? Mark my post as a solution. Proud to be a Super User! Appreciate your Kudos 🙂
Feel free to email me with any of your BI needs.
@parry2k
Thanks for reply, As per my description, I am calculating the buckets at dynamically based on the selected year in slicer. So I don't think, it can be achieved by calculated column.
Is there any alternative or workaround to get dynamic Age Bucket that can be used as column?
Hi @sonuojha1 ,
Even creating a calculated column can realize your idea.
Maybe you can refer to my .pbix file and try again.
Best regards,
Lionel Chen
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
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 |
---|---|
114 | |
100 | |
75 | |
73 | |
49 |
User | Count |
---|---|
145 | |
109 | |
109 | |
90 | |
64 |