Forum Discussion

cleemas's avatar
cleemas
Frequent Visitor
6 years ago

Two same slicer on column

Hello,   The office column displays the value from the 'SharePoint List' [Value] that belongs to the filtered month or year (the year and month can be filtered based on month and/or year '2019 Janu...
Need Help
Tips and Tricks
amitchandak's avatar
amitchandak
Super User
6 years ago

Assuming you are able to create two slicers. By using two disconnected tables or one connected and one disconnected table.

 

You can try formulas like

 

slicer 1 value = calculate(sum(table[value]),filter(table,table[month-year] in ALLSELECTED('Slicer1'[Format Month])))
slicer 2 value = calculate(sum(table[value]),filter(table,table[month-year] in ALLSELECTED('Slicer2'[Format Month])))

OR
slicer 1 value = calculate(sum(table[value]),table[month-year] in ALLSELECTED('Slicer1'[Format Month]))
slicer 2 value = calculate(sum(table[value]),table[month-year] in ALLSELECTED('Slicer2'[Format Month]))

 

Appreciate your Kudos. In case, this is the solution you are looking for, mark it as the Solution. In case it does not help, please provide additional information and mark me with @
Thanks. My Recent Blog -
Winner-Topper-on-Map-How-to-Color-States-on-a-Map-with-Winners , HR-Analytics-Active-Employee-Hire-and-Termination-trend
Power-BI-Working-with-Non-Standard-Time-Periods And Comparing-Data-Across-Date-Ranges

Connect on Linkedin