Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
9 years ago
Solved

Row based slicer

Hey guys,   I have a small problem and I'm not sure weather its possible to do it in PowerBI or not (it's easy in Excel though).   So there are 3 rows "EBIT, OPEX and Order Entry" that can be sli...
  • Anonymous's avatar
    Anonymous
    9 years ago

    A friendy coleague just helped me out, we used following measure to achieve what I was looking for, since your solution didn't work out:

     

    SumValue = IF(HASONEVALUE('Table'[KPI]);
			SWITCH(VALUES('Table'[KPI]);
			"EBIT";CALCULATE(SUM('Table'[VALUE]);ALL('Table'[EX_DT_IN]));SUM('Table'[VALUE])
		))
Anonymous's avatar
Anonymous
Not applicable
9 years ago

A friendy coleague just helped me out, we used following measure to achieve what I was looking for, since your solution didn't work out:

 

SumValue = IF(HASONEVALUE('Table'[KPI]);
			SWITCH(VALUES('Table'[KPI]);
			"EBIT";CALCULATE(SUM('Table'[VALUE]);ALL('Table'[EX_DT_IN]));SUM('Table'[VALUE])
		))
Shruti_0527's avatar
Shruti_0527
New Member
6 years ago

Hi,

How to add slicers in row headers matrix visual in power bi.