Graph Suggestion

[Anonymous]

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 the magnitude of their X values determines their width.

Has anyone seen something like this? On the marketplace or otherwise?

Thanks

[v-alq-msft]

Hi, @Anonymous 

It is unavailable that the magnitude of their X values determines their width. I'd like to suggest you post a new idea in Idea Forum , and add your comments there to improve Power BI for making this feature coming sooner.

Best Regards

Allan

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Greg_Deckler]

Had a thought about how to pull this off but couldn't quite bring it home. You might get an idea or two from it so figured I'd post it anyway.

[Anonymous]

Hi @Greg_Deckler 

I went down another path that ended up not working. Can you explain what you did in your solution and I can try that? I'm not sure how you have it set up.

[Greg_Deckler]

Did you get the PBIX that was attached? I can take a look at it and remind myself what I did.

[Anonymous]

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.