Forum Discussion
Can't use column values in visuals
Hello everyone,
I have a model that I have been bulding for a while now and everything was normal until suddenly all columns in all tables became unusable in visuals. for example, on the left is one of the tables I have in my model and for some reason, it's not being read from Power BI as a value and hence, it can't be summerized or used directly in visuals. I tried the exact same query for this table in a new .pbix file -and also for every other table- and it works fine as in the right.
I made sure that data type and summarization are set correctly as below.
can anyone help?
Thanks for you reply Josh, I found the solution of the issue here
apparently, this was caused because I used tabular editor earlier to add calculation group and then removed it, the proplem is that adding calculation groups from tabular editor alters a property called "Discourage implicit measures"
which caused the issue. Reverting this property back to false solved it.Regards,
Abdullah
2 Replies
Hi, you mentioned that you are not able to recreate this problem in a new .pbix file, but are you able to share the .pbix file where this problem is occurring? I'd like to see if something is overriding the data type and summarization setting that you are selecting.
Thanks,
Josh
Thanks for you reply Josh, I found the solution of the issue here
apparently, this was caused because I used tabular editor earlier to add calculation group and then removed it, the proplem is that adding calculation groups from tabular editor alters a property called "Discourage implicit measures"
which caused the issue. Reverting this property back to false solved it.Regards,
Abdullah
