Earn the coveted Fabric Analytics Engineer certification. 100% off your exam for a limited time only!
Problem
My visuals seem not to be affected by on page slicers, nor Page level filters, nor Report level filters.
I am using: Desktop v2.61.5192.601 64-bit (August 2018)
Example
I am using,
Through Query Editor the EventDate table has daily values from 1/1/2010 - 12/31/2020. When adjusting my Slicer to be dates of 1/1/2013 to 12/31/2016 I would expect the Column chart to adjust the axis to be between within these dates. Instead the axis shows all dates (2010 - 2020), but the [#Event Count] value adjusts to only consider those within the selected date range. This same concept holds with the Table as well; the Table has no change in values but shows all dates between 2010 and 2020. This makes me think the slicers / filters are not filtering the data table itself.
Desired Outcome
When applying a slicer I would like that slicer to affect both the axis as well as the measures, rather than just affecting the measures. I would like a column chart who's axis only shows those dates within the selected Slicer values, and includes dates within that selected timeframe who's measure may or may not be 0.
Any help is much appreciated.
Solved! Go to Solution.
Hi @MFelix,
Thanks for the response. Switching to a categorical yielded the same results; see below.
However, I think I found a solution. The "Mark as Date Table" function / button (in Ribbon--> Modeling --> Calendars tab --> Mark as Date Table) seemed to do the trick. Now both continuous and categorical work. This must be a somewhat new button as I dont recall seeing it before.
Thanks for your time though!
Hi @medward,
I believe that you are having an issue with the type of X-axis you have, if you look at your chart you have only 3 columns and I can assume if you stop on it you will get the tooltip for the years you put on the slicer.
Go on the options of the visual and to X-axis then change it from Continuos to Categorical and you should get the expected result.
when using date it assumed by default that you want continuous dates so the outcome is what you have in x-axis.
Regards,
Mfelix
Regards
Miguel Félix
Proud to be a Super User!
Check out my blog: Power BI em PortuguêsHi @MFelix,
Thanks for the response. Switching to a categorical yielded the same results; see below.
However, I think I found a solution. The "Mark as Date Table" function / button (in Ribbon--> Modeling --> Calendars tab --> Mark as Date Table) seemed to do the trick. Now both continuous and categorical work. This must be a somewhat new button as I dont recall seeing it before.
Thanks for your time though!
User | Count |
---|---|
128 | |
108 | |
99 | |
64 | |
62 |
User | Count |
---|---|
136 | |
113 | |
102 | |
71 | |
60 |