How to include data from two variables in the same chart

[rachel_luiz]

How do I put data on a Likert scale (grades 1 to 5) from the same applied research in 2 consecutive years? The sum of all bars (2018 + 2019) gives 100%, but I would like the data for each year to add up to 100%

[rachel_luiz]

Hi @parry2k ! 

Actually, I wanted the bars to appear next to each other, because I'm comparing different years. I think this chart would be very good if the data were complementary, but in my case they are more comparative.

Anyway, thank you very much for your answer!

[v-robertq-msft · Accepted solution]

Hi, @rachel_luiz 

According to your description and sample picture, I think you want to get the value in the column chart that shows the Percentage of the total group by year. Right? You can achieve this using this measure:

This is my test data based on your sample picture:

Value1 =

var _total=

CALCULATE(SUM('Table'[Value]),FILTER(ALLSELECTED('Table'),[Year]=MAX('Table'[Year])))

var _value=

MAX('Table'[Value])

return DIVIDE(_value,_total)

Then go to the Column chart and replace the Value1 with the field in the “Value”, like this:

And you can get what you want.

You can download my test pbix file here

If this result is not what you want, you can post some sample data(without sensitive data) and your expected result.

How to Get Your Question Answered Quickly 

Best Regards,

Community Support Team _Robert Qin

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

[rachel_luiz]

Hi @v-robertq-msft !

This was exactly what I needed!

Thank you very much for your help!! 😉

[parry2k]

@rachel_luiz not sure if I understood, maybe you are looking for 100% stacked bar chart.

Check my latest blog post Compare Budgeted Scenarios vs. Actuals to get a summary of my favourite Power BI feature releases in 2020

I would ❤ Kudos if my solution helped. 👉 If you can spend time posting the question, you can also make efforts to give Kudos to whoever helped to solve your problem. It is a token of appreciation!

⚡Visit us at https://perytus.com, your one-stop-shop for Power BI-related projects/training/consultancy.⚡