Forum Discussion
Assistance Needed on G/R Table – Total Column.
Hi Team, Good Morning!!
I hope you're all doing well.
I have a table like below:
| G/R | Jan-25 | Feb-25 | Mar-25 | Apr-25 | May-25 | Total |
| Sales | 380955958.5 | 306713898.6 | 306383067.8 | 283803268.4 | 51632333.22 | 1329488527 |
| MoM | ▲ 4% | ▼ -19% | ▼ 0% | ▼ -7% | ▼ -82% | ▼ -82% |
| YoY | ▼ -6% | ▼ -3% | ▲ 3% | ▼ -2% | ▼ -81% | ▼ -16% |
In the above table total needs to adjust MoM total as "-"
Note: instead of ▼-82% i need to show as "-"
Finally i need output as below. Total column i just turnoned Column Subtotals.
Could you please guide me on how to approach this?
Thank you in advance!
Best regards,
Vannur Vali.
MoM_Display =
VAR _MoM = [MoM] -- your existing MoM calculation
RETURN
IF(
ISINSCOPE('Date'[MonthYear]), -- or the relevant column used on Columns in Matrix
_MoM,
BLANK() -- or return a custom text "-" with formatting
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
4 Replies
MoM_Display =
VAR _MoM = [MoM] -- your existing MoM calculation
RETURN
IF(
ISINSCOPE('Date'[MonthYear]), -- or the relevant column used on Columns in Matrix
_MoM,
BLANK() -- or return a custom text "-" with formatting
)
Thanks,
Pankaj Namekar | LinkedInIf this solution helps, please accept it and give a kudos (Like), it would be greatly appreciated.
Dear pankajnamekar25 ,
Thank you for your prompt response. It is working as expected.
Best regards,
Vannur Vali
Hi Anonymous
You can use a conditional dynamic format string:
IF ( NOT ( ISINSCOPE ( Dates[Month and Year] ) ), "-", "#,0" )Hello Anonymous,
Thank you for reaching out to the Microsoft Fabric Forum Community.
I have reproduced your scenario in Power BI, and I was able to achieve the expected output as per your requirements.Output:
For your reference, I have attached the .pbix file containing the solution. You can review the measures, data model, and matrix’s visual setup to see how the expected output was achieved.
If this information is helpful, please “Accept as solution” and give a "kudos" to assist other community members in resolving similar issues more efficiently.
Thank you.
