Forum Discussion
Madhu155154
Helper I
Helper IHow to set Default filter for Matrix or Table
Hi everyone, I want a matrix to show values for a particular filter, L1, from KPI Level by default. Note: I will use KPI Level as a slicer. When I click on the L2 slicer, the table should display...
Hi Based on my understanding, here is my solotion
Approach I used here is -
1. created a new disconnected table with KPI values
2. switched the output based on KPI filters. formula as below:sum of target =SWITCH(TRUE(),SELECTEDVALUE('Table (2)'[KPI Level],"L1")=max('Table (3)'[new kpi]),calculate(sum('Table (2)'[Target]),'Table (2)'[KPI Level]=max('Table (3)'[new kpi])))
if this solves your purpose, please accept this as solution.
Rupak_bi
Super User
Super UserHi Based on my understanding, here is my solotion
Approach I used here is -
1. created a new disconnected table with KPI values
2. switched the output based on KPI filters. formula as below:
sum of target =
SWITCH(TRUE(),SELECTEDVALUE('Table (2)'[KPI Level],"L1")=max('Table (3)'[new kpi]),calculate(sum('Table (2)'[Target]),'Table (2)'[KPI Level]=max('Table (3)'[new kpi])))
if this solves your purpose, please accept this as solution.
if this solves your purpose, please accept this as solution.