Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Hi Community!
I believe this is possible but I am just not sure how to do it. If you have a lot of data for a certain time frame (four months), and you have a monthly slicer on the visual, but you only want the data to appear when a month is selected on the slicer and not the full four months when nothing is selected on the slicer, how can you cover it? I believe that you could cover with a blank visual and adjust settings for that blank visual to disappear when something is selected in the slicer.
Please let me know if you have any ideas.
Thank you in advance!
Solved! Go to Solution.
@MExtross wrote:
Hi Community!
I believe this is possible but I am just not sure how to do it. If you have a lot of data for a certain time frame (four months), and you have a monthly slicer on the visual, but you only want the data to appear when a month is selected on the slicer and not the full four months when nothing is selected on the slicer, how can you cover it? I believe that you could cover with a blank visual and adjust settings for that blank visual to disappear when something is selected in the slicer.
Please let me know if you have any ideas.
Thank you in advance!
There's no elegant solution, however you can achieve the goal with some tricky measure. See more details in the attached pbix file.
Measure = IF(ISFILTERED('calendar'[YearMon]),SUM('Table'[value]),BLANK())
@MExtross wrote:
Hi Community!
I believe this is possible but I am just not sure how to do it. If you have a lot of data for a certain time frame (four months), and you have a monthly slicer on the visual, but you only want the data to appear when a month is selected on the slicer and not the full four months when nothing is selected on the slicer, how can you cover it? I believe that you could cover with a blank visual and adjust settings for that blank visual to disappear when something is selected in the slicer.
Please let me know if you have any ideas.
Thank you in advance!
There's no elegant solution, however you can achieve the goal with some tricky measure. See more details in the attached pbix file.
Measure = IF(ISFILTERED('calendar'[YearMon]),SUM('Table'[value]),BLANK())
Hi, I was able to cover it using the above formula!
User | Count |
---|---|
124 | |
108 | |
99 | |
62 | |
62 |
User | Count |
---|---|
137 | |
115 | |
102 | |
71 | |
61 |