Forum Discussion

nmeliasp's avatar
nmeliasp
Regular Visitor
7 years ago
Solved

Multiple Date Column slicer

Hello i am relatively new to PowerBI and need some help

 

I have 3 columns that have dates in them simillar to example below. How can i create One slicer to see every completion in October for example? 

 

X completionY Completion Z Completion
10/1/201811/1/201810/15/2018
Need Help

14 Replies

  • AlB's avatar
    AlB
    Community Champion
    7 years ago

    Hi nmeliasp

     

    You could create a Calendar table with a relationship for example to Table[X Completion].

    The you create a simple measure:

    [Completions]= COUNT(Table[X Completion])

     

    Use a slicer with the month column from Calendar and  select the month you want.   

    • nmeliasp's avatar
      nmeliasp
      Regular Visitor
      7 years ago

      i would like to specify a month for example October and see completions from X Completion Column and Z Completion Column. Not sure if your solution willl work for that.

      • AlB's avatar
        AlB
        Community Champion
        7 years ago

        Let's see if I understand what you're after. In the table you've depicted, what would be the result then for October, 2? OR do you want separate results for each column X, Y, Z?