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?
Super Usernetanel ,
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
netanelHi 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!!!