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 everyone,
I'm trying to recreate the chart below in Power BI (originaly created in Excel)
https://pasteboard.co/IQTroZi.png
You can see that the X axis has two categories.
The dates are at the bottom, sub-categorized by number of Open X Closed items.
It's pretty easy to create this in Excel, but Power BI seems not to be capable of doing so.
I've found other help requests in the forum for similar issues, and there is a lot of people voting for Microsoft to implement this to the software.
However, as this is not yet solved, I was wondering if anyone would have a work around.
Maybe using a Bridge Table? Not sure, can someone please give me a light?
Thank you!
@Anonymous ,
You may create custom hierarchy column using column [Dates] and [Open X Close], then enable the "concatenate label" option in X-axis.
Community Support Team _ Jimmy Tao
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi @v-yuta-msft ,
It seems like the Grouping method doesn't work with more than 1 column. I tried to follow the steps in the video you attached, but the tool prevents me of mixing the "Dates" and "Open x Close" columns together.
The "concatenate label" option in X-axis was already on.
Any other ideas?
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 |
---|---|
110 | |
94 | |
81 | |
66 | |
58 |
User | Count |
---|---|
151 | |
121 | |
104 | |
87 | |
67 |