Help related with bar chart

Question

I have a table which contains user_id, count_of users, user_distribution (If user appers once then 1x, if twice or thrice then 2-3x and so on), and index. Please follow screen shot for details.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;Now I have a bar chart which looks like this.&nbsp;What I want now to make this chart a relative which means for 1x (2017 value should be considered as 100% and then whatever 100+% in 2018 , and same for the 2-3x and rest).&nbsp;How could I achive this, please&nbsp;guide me here.&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;&nbsp;

anonymous · Accepted Answer

Anonymous,Create measure in your table following the guide in the PBIX file below and check if you get expected result. If not, please help to post your desired result here.https://1drv.ms/u/s!AhsotbnGu1NogyuaJmvITA1g-RP8Regards,Lydia

Forum Discussion

Help related with bar chart

1 Reply

Related content

Filtercontext with date relation

Relation

Related employees via bridge

Line chart

Comparison Chart