Forum Discussion
Graph Suggestion
Hi everyone, My client requires a certain type of graph, and I can't seem to find anything like it. The bars are all different categories, like industry, or facility or something and th...
Did you get the PBIX that was attached? I can take a look at it and remind myself what I did.
Sorry, I missed that pbix. I downloaded it and took a look. Can you please explain the DAX table that you made?
Also, was there a reason to use a clustered column chart? I tried switching it to stacked and got closer to the visual I'm looking for:
Basically my data has facilities, a value and production:
| Facility | Value | Production |
| East | 50 | 450 |
| West | 200 | 900 |
| North | 35 | 250 |
| South | 120 | 340 |
The width of the column is actually the % total of production, so the X axis adds up to 100%. For the East facility, the Y axis value would be 50, but the X-axis width would be ~23.2%, or 50 high and 23.2 across. Am I going about this all wrong? Should I be using a 100% stacked column chart? The user wants to be able to see, at a glance, what the value is for a facility and their % of total production.