How to get individual values in clustered column chart

Praj — Thu, 04 May 2023 09:45:48 GMT

Hi Everyone,

I have been stuck with a problem where I need to identify the individual values of a column and stack that together in a column bar chart.

For example, I have below survey Q&A data and I need to find the individual contributions of each country and then put that value in the bar chart.

The output above gives me the overall contributions of each countries, however if I select any individual country(for ex, if i select France, I get the below values where approx, 23% have choosen option 1, 25% have choosen option 2 and 3 and 13% have choosen option 4 and 5)

I am looking to have the above same values when I deselect France from the filter in comparasion with other countries. I know the value gets divided by overall respondents if i clear filteres but is there any way on how I can get individual values of each countries together.

I have attached the .pbix file for reference in the below shared link. Any solution/approach is highly appreciated.

https://drive.google.com/drive/folders/1SoUdJDzWLtrFCvDhNmaB04LiXNMxCXyJ?usp=share_link

Cheers,

Praj

Re: How to get individual values in clustered column chart

tamerj1 — Thu, 04 May 2023 12:34:32 GMT

Hi Praj
Please refer to your sample file updated as requested.

CountQ123 = VAR Count1 = DISTINCTCOUNT ( 'Q1,Q2,Q3'[Index] ) VAR TotalCount = CALCULATE ( DISTINCTCOUNT ( 'Q1,Q2,Q3'[Index] ), ALLEXCEPT ( 'Q1,Q2,Q3', 'Q1,Q2,Q3'[Country] ) ) RETURN DIVIDE ( Count1, TotalCount )

Re: How to get individual values in clustered column chart

Praj — Thu, 04 May 2023 13:08:49 GMT

Hi tamerj1 ,

Thanks for the approach. The solution worked.

Cheers,

Praj

topic Re: How to get individual values in clustered column chart in DAX Commands and Tips

How to get individual values in clustered column chart

Re: How to get individual values in clustered column chart

Re: How to get individual values in clustered column chart