Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
6 years ago

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...
Need Help
Greg_Deckler's avatar
Greg_Deckler
Community Champion
6 years ago

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's avatar
Anonymous
Not applicable
6 years ago

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's avatar
    Greg_Deckler
    Community Champion
    6 years ago
    Did you get the PBIX that was attached? I can take a look at it and remind myself what I did.
    • Anonymous's avatar
      Anonymous
      Not applicable
      6 years ago

      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:

      FacilityValueProduction
      East50450
      West200900
      North35250
      South120340

       

      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.