Forum Discussion
Anonymous
7 years agoNot applicable
Hiding Rows for Measure taken in Row
HiHiding Rows
I have two measures Amount and Revenue Percentange, I have taken the measures on rows and dates in columns. Want to display the rev % for the top level only. The problem here now is I want to hide the rows other than for the total in the hierarchy. Could you please help if this is achievable.
Thanks&Regards,
cskoch
1 Reply
- v-yulgu-msftMicrosoft Employee
Hi Anonymous,
Please try the method mentioned in below link:
https://powerpivotpro.com/2013/03/hasonevalue-vs-isfiltered-vs-hasonefilter/
Best regards,
Yuliana Gu