Forum Discussion
Item group slicer
<p>Hi,</p><p> </p><p>I have a matrix visual with customers (rows), item groups (columns) and sales.</p><p> </p><p>I would like to build a slicer that contains the item groups and shows all the customers with sales in the selected item group.</p><p>I also want to see the sales in the selected and the non-selected item groups. </p><p> </p><p>When I add a slicer with item groups I can see all the customers with their sales in this group but the other item groups disappear.</p><p> </p><p>Is there any possibily to build a slicer like that?</p><p> </p><p>Thank you very much!</p><p> </p><p>Thomas</p>
2 Replies
- amitchandak
Super User
Anonymous , first of all you need an independent item group slicer
then you can have meausre like
selected = calculate([meausre], filter(Table, Table,[item group] in allselected( 'item group'[ item group]) ))
not selected =
var _tab = except( all( 'item group'[ item group]) ,allselected( 'item group'[ item group]) )
return
calculate([meausre], filter(Table, Table,[item group] in _tab ))
If you need them with a column(having measure names) , the create a calculation group
Need of an Independent Table in Power BI: https://youtu.be/lOEW-YUrAbE
Calculation Groups- Measure Slicer, Measure Header Grouping, Measure to dimension conversion. Complex Table display : https://youtu.be/qMNv67P8Go0
- v-luwang-msft
Community Support
Hi Anonymous ，
Has your problem been solved, if so, please consider Accept a correct reply as the solution or share your own solution to help others find it.
Best Regards
Lucien
