Forum Discussion
Subtotal text value as dynamic
Hi Team,
Is it possible to change the subtotal labels as dynamic. Currently there is no option to change subtotal labels to dynamic based on the values. Can you all help on this.
Hi prakash11440278 ,
Based on your description, you can use INSCOPE() to create a measure as follows.
For example, I just want the subtotal of column "C2" to be displayed.
Measure = IF(ISINSCOPE(test_subtotal[C2]),SUM('test_subtotal'[Value]))Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
11 Replies
prakash11440278 , You have an option two change "row subtotal label". I think you can only rename "total" part of it
HI amitchandak ,
Yes. If we add the subtotal text value it will be applicable for entire column, i dont want that. In above example i need to display as dynamic means x site total, y site total & z site total these all are dynamic.
prakash11440278 , I doubt that is possible. Good idea to have - https://ideas.powerbi.com/ideas/
Hi prakash11440278 ,
Based on your description, you can use INSCOPE() to create a measure as follows.
For example, I just want the subtotal of column "C2" to be displayed.
Measure = IF(ISINSCOPE(test_subtotal[C2]),SUM('test_subtotal'[Value]))Result:
Hope that's what you were looking for.
Best Regards,
Yuna
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.
Hi Anonymous ,
Thanks for the reply. Here my requirement is different, i dont want hide the subtotals values. I want to change subtotal labels should be dynamic. Currently if we change the subtotals name it will change entire row. That i dont want to do that.
Hi prakash11440278 ,
Thanks for your reply. So do you want to change every single subtotal label? I doubt if it is possible. Power BI does not seem to support the feature you mentioned. The "Row subtotal labels" refers to all subtotals and grandtotal labels.
Hope that's what you were looking for.
Best Regards,
Yuna
Hi prakash11440278 , we have a Total label for matrix and table visual, did you tried that?
