Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Replace value of Matrix columns

Hi community,   I have a Matrix with more than 40 columns where all have the same big value, 999.90....... This big value is set in the database, in order to show that there is connection.   How...
Interesting Links
Need Help
Show and Tell
  • Greg_Deckler's avatar
    Greg_Deckler
    5 years ago

    Anonymous Are you saying you need to do this in Power Query when ingesting the data or in a Matrix visual? If in a visual, create a measure like Measure = IF(MAX('Table'[Value])=999.90,0,MAX('Table'[Value]))

  • Anonymous's avatar
    Anonymous
    5 years ago

    Hi Anonymous ,

    You can update the formula of measure as below:

    New measure = IF ( [original measure] >999, 0, [original measure] )

    If the above one is not working for your scenario, please provide your sample pbix file (exclude sensitive data) if it is possible. Later we will provide you a suitable solution base on your sample file. Thank you.

    Best Regards

Greg_Deckler's avatar
Greg_Deckler
Icon for Community Champion rankCommunity Champion
5 years ago

Anonymous Are you saying you need to do this in Power Query when ingesting the data or in a Matrix visual? If in a visual, create a measure like Measure = IF(MAX('Table'[Value])=999.90,0,MAX('Table'[Value]))