Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
8 years ago
Solved

Creating a column with fewer values form months

Hello,   In my calendar table, I have Jan 2015 until Dec 29018.   I would like to put a filter  (slicer) on the page that shows only (!) JAN18 until current Month,   I tried to create a new cal...
Need Help
  • v-lili6-msft's avatar
    v-lili6-msft
    8 years ago

    Hi@Tamir

    For value (blank) in this column may have many different corresponding values in other columns, So it can’t be sorted by another column.  

    And filter the whole report/page by this column is just to hide the "Blank" in the visual you don’t want to see, so you can just add a visual level filter on this visual.

     

     

    Best Regards,

    Lin

Anonymous's avatar
Anonymous
Not applicable
8 years ago

Thank you v-lili6-msft

 

I was wondering if it possible to sort the column 

Months to Date(filter)

by another column.  
I do not want to filter the whole report/page by that column as other visuals need to be shown for other dates as well.

 

Thank you,

Tamir

v-lili6-msft's avatar
v-lili6-msft
Community Support
8 years ago

Hi@Tamir

For value (blank) in this column may have many different corresponding values in other columns, So it can’t be sorted by another column.  

And filter the whole report/page by this column is just to hide the "Blank" in the visual you don’t want to see, so you can just add a visual level filter on this visual.

 

 

Best Regards,

Lin