Forum Discussion
Two slicer on same column
Anonymous,
I know how to help you. You need a feature called 'Edit interactions' - https://docs.microsoft.com/en-us/power-bi/service-reports-visual-interactions
For instance, you have one two slicers and two tables like below:
edit interactions 1
Then select the first slicer and go to Format -> 'Edit interactions' and disable filter on a second slicer and second table.
Then click on the first table and do completely the same.
After that click on the second slicer and disable filter on a first slicer and first table. Do completely the same for the second table.
As a result, you be able to filter both slicers separately like below:
edit interactions 2
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!
Hey Ruslan
Thanks for the quick reply. Yes the edit interaction does that but the main goal is to have a 1 v 1 comparison, for eg a Pie chart for the two months (in your example).
Edit Interation works when there are two seperate graphs but not when there is one graph.
The result -> compare the two Partners and generate and 1 v 1 comparison.
I hope this helps
ThanksHi Anonymous,
It can be done as well. See a screenshot and details how to achieve that below:
month filter
1. Create a calculated table using a formula:
MonthFilter1 = DISTINCT(VALUES(Table1[Month]))
where
- Table1 is your table name
- [Month] is your column of table Table1 to be used as a filter
- MonthFilter1 is your name for this calculated table, can be free text
Some examples of what is a calculated table and how to create it - https://www.youtube.com/watch?v=aKX1E3krl4I
2. Add a calculated measure to the table MonthFilter1:
MonthFilter1 Value = SELECTEDVALUE(MonthFilter1[Month])
Examples - https://www.youtube.com/watch?v=yn2bXVQJLx8
3. Create a second calculated table MonthFilter2 and measure MonthFilter2 Value in it (replace all 1 digit with 2 in formulas, except table Table1 name)
4. Create a calculated measure in Table1:
SalesMonth1 = SUMX(FILTER(Table1,Table1[Month]=MonthFilter1[MonthFilter1 Value]),Table1[Sales 2017])
Where
- SalesMonth1 is a name of your measure
- Table1 is a name of your main table
- MonthFilter1 is a name of a first calculated table
- [MonthFilter1 Value] is a name of a measure from a table MonthFilter1
- [Sales 2017] is a name of your numeric field which you want to compare for different filters
5. Create a similar measure SalesMonth2 in the same table Table1 (replace all 1 digit with 2 in formulas, except table Table1 name)
Regards,
Ruslan
-------------------------------------------------------------------
Did I answer your question? Mark my post as a solution!Been looking for an hour how to solve this. Helped a lot. Cheers and thanks!
Hi Ruslan / zoloturu ,
I was wondering if there is also a way to do this for multiple periods? Your method works brilliantly but when I want to filter for multiple periods it returns no results.
Thanks in advance,
