Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and a 50 percent discount on exams.
Get startedEarn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
Dear Power BI Community,
I have a measure that calculates the total of something and I have not found out a way to not use a measure. Is there a way to create bins for a measure?
My table is set up like this from a report:
ID | Check Date | Hours |
124 | 1/10/2020 | 10 |
124 | 1/10/2020 | 10 |
124 | 1/3/2020 | 15 |
548 | 1/3/2020 | 5 |
548 | 1/10/2020 | 6 |
I do have a measure that gets me the following table:
ID | Hours |
124 | 35 |
548 | 11 |
My end goal is to be able to make a histogram with a unique count of ID as the value and hours (bins) as the x-axis. So I need to make sure total hours is a calculated column.
Any help on this would be appreciated
Hi @Anonymous ,
You can have a look at this video for custom bins and creating histograms.
Regards,
Harsh Nathani
Did I answer your question? Mark my post as a solution! Appreciate with a Kudos!! (Click the Thumbs Up Button)
Hi @Anonymous
On the attached, you will find a file with a solution.
Essentially you can just create a relationship between your summarized table and Original table and later use Bins table to slice end dice.
The attache has two versions of bins table Power Query and DAX that you already have.