Forum Discussion
Display data from the same column with different format
Create two coulmn and apply the transformation to get the desired datatype asd rename the column as
Euro Column
Percent Column
Now create a new table
SelectionTable
Position Unit
1 Euro
2 Percent
Now Create two measure
1. SelectedSortMeasurePosition = MIN('Selection'[Position])
2. SelectedSortMeasure = SWITCH(Selection[SelectedSortMeasurePosition],1,'Table'[Euro Column],2,'Table'[Percent Column],BLANK(),'Table'[Euro Column])
Drop a slicer and in field choose 'SelectionTable'[Unit]
In Chart Drop SelectedSortMeasure as field
Now according to the selected slicer the type will change
If this is what you required then please like and accept this as solution.
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
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
