Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I want to show country wise slaes % based on quater. In filter when i select quater 1 i need 3 graph to show the sales %. So my quater 1 is Dec , Jan and Feb. So chart 1 should have Dec sale %, Chart 2 with Jan Sale % and chart 3 with Feb sale %. For all this the X axis should be country that we are selecting.
% of total sales?
create a measure
%ofSales =
VAR totalsalesAllCountry =
CALCULATE ( SUM ( Sales[Sales] ), ALL ( Sales[Country] ) )
VAR totalsales =
CALCULATE ( SUM ( Sales[Sales] ) )
RETURN
DIVIDE ( totalsales, totalsalesAllCountry )
place on your visual and as long as you are linked to the data etc should apply it correctly
Proud to be a Super User!
Hi,
Thanks for the reply. I already have the Sale % with me. I need the help to visulaise it. So in my filter i have country, quarter and month. So when i select quarter 1 i need 3 seperate graph to come.
Graph should have Dec data , Graph 2 should have Jan data and Graph 3 should have Feb data.
@unnijoy check this out and see if it helps, not really sure what you asking
https://www.youtube.com/watch?v=_Afcj8mT5_Q
Proud to be a Super User!
User | Count |
---|---|
128 | |
109 | |
100 | |
65 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |