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

Anonymous's avatar
Anonymous
Not applicable
5 years ago

Hi Greg_Deckler,

 

Only in the Matrix visual.

I need all 999.90....... values to visually change them in the Matrix to zero.

Just this. 

Any idea how ?

Is it necessary to create 40+ Measures for each Column, so to get rid of this value ?

 

Kind Regards,

Antonios Katsikinis 

Greg_Deckler's avatar
Greg_Deckler
Community Champion
5 years ago

Anonymous I need a sample of your data as I am not understanding what you have exactly. Perhaps you need to unpivot your columns in your dataset>