percentage of total based on category with date range

[amazinfarah]

Hi Guys,

i have report where i am showing line chart. i want to show as total of percentage as you can see i am showing as count of id on date and and based on category

let suppose any data point show as below

count of order id          segment             order date     

10                                  furniture            30/01/2019     

20                                 office supplies    30/01/2019      

70                                 technology         30/01/2019      

what i want in line chart show as total percentage like below

count of order id          segment             order date        percentage

10                                  furniture            30/01/2019      10%

20                                 office supplies    30/01/2019      20%

70                                 technology         30/01/2019       70%

like total count of day is 100 and 100% percentage is splitted by category (legend) how can i do that? date slicer in place too so range user can change

[amitchandak]

@amazinfarah , Drag the count measure again, right click on the meausre in visual pane and use option show as Percent of total

of create meausres like

divide([count of order id], calculate([count of order id], all(Table)))

or

divide([count of order id], calculate([count of order id], allselected(Table)))

refer: https://www.youtube.com/watch?v=6jTildcV2ho