Forum Discussion

errepinna's avatar
errepinna
Helper I
5 years ago
Solved

Grouping histogram bars

Hello everyone,   I'm trying to do something simple. I got different values of the same kind referring to the same entities, and I want to group them in an histogram together.   I made an excel f...
Need Help
errepinna's avatar
errepinna
Helper I
5 years ago

Hello, thank you for your help!

However, this isn't what I'm trying to achieve. I'm already using an all-page filter to select a single "sale type" (RIC, DID, etc). 

 

On top of that, I'm trying to display the two columns not piled up but separated, so that I can visualize their different height.

 

So the information is, for example: I want to see, for each location, how much (in %) of total sale A was realized on type DID compared to all Sale A. So I put a filter on the view for type DID and calculate the the %impactonA by removing the DID filter from the denumerator.

I do the same with sale B.

I want to see them close together instead of piled up. I don't care about having the different types on the axis because each type gets his view.

 

I'm sorry if I wasn't clear about it before.

v-kelly-msft's avatar
v-kelly-msft
Community Support
5 years ago

Hi  errepinna ,

 

Is below what you need?

Check the updated .pbix file attached.

 

Best Regards,
Kelly

Did I answer your question? Mark my post as a solution!

  • errepinna's avatar
    errepinna
    Helper I
    5 years ago

    Worked out! Thanks!