Forum Discussion
nmeliasp
7 years agoRegular Visitor
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 exam...
- 7 years ago
You may try using CALCULATE Function to change the context.
https://www.sqlbi.com/articles/filter-arguments-in-calculate/
AlB
7 years agoCommunity Champion
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.
- nmeliasp7 years agoRegular Visitor
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.