Forum Discussion
Post ProdigyMatrix Table
if its currency then try this one.
Net USD average per Day for Budget = VAR result = CALCULATE ( [Net USD average per Day], 'Revenues DB'[Data Source] IN { "Budget 2021" } ) RETURN FORMAT ( result, "$-#0.00" )If its still not works then is it possible for you to share your PBI file after removing sensitive data?
Community ChampionHi netanel ,
1. Column header we cant remove but we can change its background and text color as white, which you already did.
2. I want to highlight a row from the table and make it a different background Is there such a possibility? - You can change it based on certain conditions only or you can change completely.
3. You can use below measure for this:-
Measure = IF(ISBLANK(SUM(financials[Profit])),0,SUM(financials[Profit]))You can refer your file here:-
Thanks,
Samarth
Post ProdigyHi Samarth_18
1. Thanks
2. iam looking for change it based on certain conditions, but i dont no how
3.
can you help mr to put the dash "-"
her:
- Samarth_18
Try below code:-
Net USD average per Day for Budget = VAR result = CALCULATE ( [Net USD average per Day], 'Revenues DB'[Data Source] IN { "Budget 2021" } ) RETURN CONCATENATE ( "-", result )- netanel
Hi Samarth_18
i get this
I tried alone even before I asked and I can not replace the empty cell really weird
- Samarth_18
Try this one:-
Net USD average per Day for Budget = VAR result = CALCULATE ( [Net USD average per Day], 'Revenues DB'[Data Source] IN { "Budget 2021" } ) RETURN FORMAT ( result, "-0.00" )