Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi,
Is it possible to have a visulization defaulting to a time range but still respond to other time ranges selected through slicers?
For example, I want to have pie chart that shows commission earned during "last month" by line of business. However I want to have a separate slicer in the same page that shows fiscal years/ quarters/months as the case may be. I am looking for functinality where in by clicking last fiscal year, the pie chart should show data for last year instead of its default "last month"
I am a new user and still learning. Thanks in advance for any help!
Take a look at ISFILTERED and ISCROSSFILTERED functions.
https://msdn.microsoft.com/en-us/library/gg492197.aspx
Thank you very much! I shall try this.
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |