Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
I am new to Power BI and am trying to build a trend chart showing the % for one store in specific (filtered) and % of of all our stores combined (no filter applied). Can I show these in one trend chart?
Below is an example including only the one store in specific. I am trying to figure out how to add to the same chart an additional line with all stores combined.
Thanks in advance for the help!
Bianca
This can probably be acheived using the ALL function. https://docs.microsoft.com/en-us/dax/all-function-dax
So maybe one measure for the specific store CALCULATE(,FILTER()) and then another measure for all of the stores CALCULATE(,ALL())
Do you have a little more information about the current measure/value/data?
Thanks a lot for the help! I had to do a few extra steps, but this put me in the right direction!
@Anonymous
I have a similar question but more so for a scatter chart.
Any idea if it can be done for a scatter chart?
Regards
I have not had a use case for a scatter yet so I am not familiar enough to even make a guess. Good luck!
User | Count |
---|---|
140 | |
113 | |
104 | |
77 | |
64 |
User | Count |
---|---|
135 | |
120 | |
101 | |
71 | |
61 |