Forum Discussion
Icon Conditional Formatting and Calculation Groups using Field Values
Ok I think I have discovered the root cause.
Because the underlying measure is originally of a type that is Integer, it is not adjusting to the type String that the Calculation Group is adjusting it to. And a field value source requires a measure to have a type of String.
So if I convert the measure to output a string initially and then do the switch on that through the Calculation Group it is now selectable.
So the problem is that the measure maintains it's original Data Type even if the Calculation Group is changing the output.
Hi Ashes ,
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.
If the information is sensitive please share it trough private message.
That's totally fine. I'm greatful for trying to assist me.
I'm pretty sure your attempt at helping me is what assisted me in figuring it out. Sounding it out with someone always helps 🙂