Matrix Table

[netanel]

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:

https://1drv.ms/f/s!AonyYI-TdspHgUhwngZ6OKvpnSsc

[Samarth_18]

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:-

https://file.io/LzIR93ZCR4Gn 

Thanks,

Samarth

[netanel]

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" }

))

[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" )

[netanel]

@Samarth_18 

Same result

Maybe becuse the format is currency?

[Samarth_18 · Accepted solution]

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? 

[netanel]

Hi @Samarth_18 

Unfortunately it also does not work and I do not have a file I can share, I think maybe the problem is that the empty spaces are zero and not just Blank
Anyway you have helped me a lot so far
I will mark your answer as a solution

[amitchandak]

@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/...

[netanel]

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 formatting

3. 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!!!