Forum Discussion

medward's avatar
medward
Regular Visitor
8 years ago
Solved

Filter / Slicer not affecting Chart Axis nor Table

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, ...
  • medward's avatar
    medward
    7 years ago

    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!

MFelix's avatar
MFelix
Icon for Super User rankSuper User
7 years ago

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

medward's avatar
medward
Regular Visitor
7 years ago

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!