Forum Discussion
Unable to add Column to Visual
I recently installed Tabular Editor 3 to my pc hoping to create calculation groups and take control of what shows up in my data labels for certain visuals. Ever since doing that I have been unable to add certain columns to my visuals. If I create a measure for the column Power BI will let me add that to the visual but not the column itself. I have tried dragging and dropping the column into the Y Axis part of my visual, using the "Move to" option on the column and using the check box on the column. None of these methods adds to column to the Y axis. It will allow me to put the column in the X axis only.
I since uninstalled Tabular Editor and deleted the Calculation Groups I made. The issue with the columns still persists. Now I'm not sure if Tabular Editor was the problem in the first place. I just know the issue started when I created the Calculation Groups the first time.
Has anyone run into this issue before and is there anything I can do before I submit a support ticket to Microsft?
When adding calculation groups to a model, Tabular Editor sets the model property DiscourageImplicitMeasures to true, since this is a requirement for calculation groups to work in the first place. In other words, if you want calculation groups in your model, you can't have implicit measures (i.e. adding column aggregations directly to visuals). Instead, you'll need to create explicit measures using DAX.
So if you want to undo this, you'll need to open the model in Tabular Editor once again, delete your calculation groups, and set DiscouargeImplicitMeasures back to false.
4 Replies
- dotykier
Advocate I
When adding calculation groups to a model, Tabular Editor sets the model property DiscourageImplicitMeasures to true, since this is a requirement for calculation groups to work in the first place. In other words, if you want calculation groups in your model, you can't have implicit measures (i.e. adding column aggregations directly to visuals). Instead, you'll need to create explicit measures using DAX.
So if you want to undo this, you'll need to open the model in Tabular Editor once again, delete your calculation groups, and set DiscouargeImplicitMeasures back to false.
This is exactly what I was looking for. Thank you for your response and explanation of the issue.
Hi DavidBrunaugh ,
Please try to uninstall and install the Power BI Desktop.
Thanks for your efforts & time in advance.
Best regards,
Community Support Team_ Binbin Yu
If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.Thank you but even after a fresh install of Power BI Desktop I still cannot add these columns to my visuals.
