Forum Discussion
Matrix Table
Hey All!
I have a number of issues with my matrix table and would love to help
1. I have a table with titles that I do not need, is there a way to delete the titles?
(Or another idea to make it look better?
2. I want to highlight a row from the table and make it a different background Is there such a possibility?
3. Where there is an empty cell I can insert - instead?
Attaches the file plus the data
Thanks for the helpers!
Link:
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?
10 Replies
netanel ,
1. I have a table with titles that I do not need, is there a way to delete the titles?
You can switch of title from table property in the visualization tab
2. I want to highlight a row from the table and make it a different background Is there such a possibility?You have an option for Style. Or you have to do conditional formatting for all columns
3. Where there is an empty cell I can insert - instead?You can try creating a measure only for conditional formatting and create color measure
colour =
var _sale = [sales]+0 //sales +0 to remove blank
return
Switch(true(),
_sale< 2000 , "red", "green"
)
and use that in conditional formatting using field value option
Conditional formatting the Pie Visual: https://community.powerbi.com/t5/Community-Blog/Power-BI-Conditional-formatting-the-Pie-Visual/ba-p/1682539
Hi Master! amitchandak
1. I know but I got confused this is not the title of it
Column headers
2. I'm looking for a different background for a specific line and have not found anything that helps me in conditional formatting3. I do not need a colored cell, I just need a dash "-"
Sorry I was not clear enough
If you can get into the file I attached it is really short and shows all the issues clearly
Thanks!!!
Hi 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
Hi 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:
Net USD average per Day for Budget =(CALCULATE([Net USD average per Day],'Revenues DB'[Data Source] IN { "Budget 2021" }))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 )
