visualisations
4 TopicsHow to show percentage of total
I have a table containing sold shoes by customer. How do I visualize the sold shoes per sex as a percentage of the total order? So the nominator = total order quantity per sex and the denominator = total order quantity Orderno Itemnr OrderQuantity Clientno Sex 100 A 4 10359 Girl 101 B 5 10160 Girl 101 C 6 10160 Boy 101 D 1 10160 Boy 102 A 2 10175 GirlSolved1.1KViews0likes3CommentsChart order by last 12 Month: Start to end
Hello, I'm showing the last 12 months( last month is May 2020 ) data but I'm unable to show order like from start to end (June to May) See the graph : (There is no data for some months so it's ok if some months are not in the graph) So actual graph order: September, November, May, July, January, December, April What I want: July, September, November, December, January, April, May What I already did till for order : 1.Try to change the sort by rank column but got this error : 2.Also, I can show perfect order if I add the year from Date Hierarchy but its add year in the axis which I don't want like this: May 2020 I attach a file please take a look: testFile.pbix Thanks In advanceSolved1.2KViews0likes2CommentsLegend In Bar Chart With Dynamic measure
Hey guys, I am having a bit of trouble in some visualisation requriement from the client. I have a measure : Switch = SWITCH(MIN('Table'[Questions]),"Ques1",'Correlation Measures'[Correlation 1], "Ques2",'Correlation Measures'[Correlation 2, "Ques3",'Correlation Measures'[Correlation 3], "Ques4",'Correlation Measures'[Correlation 4], ) This has to be plotted on a bar along with a category legend according to the correlation value such as "Highly correlated " or "Low Correlation". Please help how can i add legend to the bar graph guys?1.4KViews0likes2Comments