Matrix table to show Overall value as default when slicer is not selected any thing

[Anonymous]

Hi all,

I have Region column as slicer with Overall like (Overall, US, UK). Also I have Martix table with Date, Sales person, Target, and other columns.

I need to show my Matrix table default values for Overall, if nothing is selected in my Region Slicer.

Any body can help me!!

Regards,

Murali

[v-yiruan-msft]

Hi @Anonymous ,

If the above posts help you resolve your problem? If yes, could you please mark it as Answered? It will help other member in the community easier to find it if they face the similar problem with you. Thank you.

Best Regards

Rena

[v-yiruan-msft]

Hi @Anonymous,

Please check the following documentations, hope they can help you resolve your problem.

http://www.dagdoo.org/enable-select-all-option-for-slicer-power-bi/

https://powerpivotpro.com/2018/12/setting-a-default-slicer-selection/

If the above documentations are not applicable in your scenario, please provide some sample data(exclude sensitive data).

Best Regards

Rena

[amitchandak]

@Anonymous 

Have measure like this

measure =

if(isfiltered(Table[Region]),[Measure]),calculate([Measure],Table[Region])="All Region"))

Refer :

https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/