Forum Discussion

netanel's avatar
netanel
Post Prodigy
4 years ago
Solved

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...
Need Help
  • Samarth_18's avatar
    Samarth_18
    4 years ago

    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's avatar
netanel
Post Prodigy
4 years ago

Samarth_18 

Same result

Maybe becuse the format is currency?

Samarth_18's avatar
Samarth_18
Community Champion
4 years ago

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's avatar
    netanel
    Post Prodigy
    4 years ago

    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