Measure works in table but not chart
I've got a table with multiple different data types. The table looks like this: stat_type Name Value Decimal ZXC 1.5 Decimal QWE 5.6 Percentage TYU 0.80 And DAX code like this: Switch_value = VAR stat_type = SELECTEDVALUE(data[stat_type]) VAR p = FIND ("Percent", stat_type, 1, 2) // in my case not all values are as clear but a percent but it starts with that. VAR _d = SELECTEDVALUE(CIA[value]) return IF(p == 1, FORMAT(SUM(CIA[Percentage_of_value]), "Percent" ), FORMAT(_d, "Fixed")) I can see from a card on the page it correctly works out the stat type, then the correct part of the if statement is found. When using a table it works fine. But whenever I use any type of graph, its blank. Anyone know why / how to fix it?
Looking for specific text in cell based on another column
I'm trying to do a Find/Mid/Match in Power Query, but I'm not sure how to do it. Basically, I have a long list of article numbers and article names - inside these articles names it's stated which colour the product is. The issue is that it's not always in the same place. I have a query named "X_Colours" with one column "Colours" type is Text. Other query is "Items" with two columns "Item No" (Number) and "Name" (Text). I would like a custom column that looks in "Items" "Name" for a similar value from "X_Colours" "Colours" column. If it finds the same value, it should return the value from "X_Colours" if not, it should just return something like "Unknown", so I can manually look for the colour and add it to the list. Is this possible or do I have to create a new table and use an excel formula and then add it back into the query? Thanks in advance!