Forum Discussion
Measure does not work with "string" values
Hi Anonymous ,
On https://www.phdata.io/blog/switching-metrics-in-power-bi/ I had found a blog that explained the setup of a switching metrics.
This was quite interesting and I tried…and it worked. From now I had – on the one hand – a nice slicer that allowed me to select between EUR currency, local currency and order quantity and -on the other hand – another visual that automatically changed from EUR to local currency or quantity. So far, so good!
Now it is my intention to adjust this switching approach.
The slicer that is based on a table that I had to create manually, should allow me to select specific options that our instruments can be built off.
Our instruments consists of a model code that can comprise of up to 32 different features and for each of these features you can select one option.
Let’s say the model code is VR1C9K7HD4100LTRXA131WA0…and I would like to know details about feature 10 (10th position of the model code).
From my slicer I would like to select e.g. “Option 10” and another visual (table or matrix) should list all available options as I had tried to explain with my original posting.
So the measure that I am looking for should return rather text than figures, as my sample data should show.
Sorry, if my explanation did confuse you…
Hi Orstenpowers ,
That seems like a big gap from your original screenshot, and I don't quite understand your intent to sum it up. Based on the sample data you provided, what do you expect the expected results to be?
Best regards,
Community Support Team_ Scott Chang
Hi Anonymous ,
On https://www.phdata.io/blog/switching-metrics-in-power-bi/ I had found a blog that explained the setup of a switching metrics.
This was quite interesting and I tried…and it worked. From now I had – on the one hand – a nice slicer that allowed me to select between EUR currency, local currency and order quantity and -on the other hand – another visual that automatically changed from EUR to local currency or quantity. So far, so good!
Now it is my intention to adjust this switching approach.
The slicer that is based on a table that I had to create manually, should allow me to select specific options that our instruments can be built off.
Our instruments consists of a model code that can comprise of up to 32 different features and for each of these features you can select one option.
Let’s say the model code is VR1C9K7HD4100LTRXA131WA0…and I would like to know details about feature 10 (10th position of the model code).
From my slicer I would like to select e.g. “Option 10” and another visual (table or matrix) should list all available options as I had tried to explain with my original posting.
So the measure that I am looking for should return rather text than figures, as my sample data should show.
Sorry, if my explanation did confuse you…