Forum Discussion

augustindelaf's avatar
augustindelaf
Icon for Impactful Individual rankImpactful Individual
9 years ago

Display data from the same column with different format

Hi,    My question seems very simple but I can't do it !   in my data model I have a column that contains decimal numbers, but according to the value of another column ("euro", "percent"), I want...
Data Modeling
augustindelaf's avatar
augustindelaf
Icon for Impactful Individual rankImpactful Individual
9 years ago

Hello kaushikd,

 

many thanks for your help.

 

your method works fine until the 2nd measure that did not work.

I guess it was : "SelectedSortMeasure = SWITCH(Selection[SelectedSortMeasurePosition],1,'Table'SUM[Euro Column],2,'Table'SUM[Percent Column],BLANK(),'Table'SUM[Euro Column]) ?

 

anyway, the problem is that, in the end, I only have the data field "SelectedSortMeasure", and I have to give a data label to it. And the data label can only be of one type. Right?

 

A colleague proposed me another option : like you i split the data in the beginning, and then I convert it to text format, and then I create conditional columns to concanete the text values with "EUR" or "%" if the values of the other columns are "Euro" or "Percent"

 

Do you think it can work easily? (I am dealing with another pb right now... :(   )

many thanks to you anyway

parry2k's avatar
parry2k
Icon for Super User rankSuper User
9 years ago

augustindelaf solution you listed will work. do you need help on how to put this together?

 

 

  • augustindelaf's avatar
    augustindelaf
    Icon for Impactful Individual rankImpactful Individual
    9 years ago

    Hi parry2k,

     

     

    We finally decided not to do things like that, but in another way.

    this would have been a pleasure to have your help.

     

    thanks