Forum Discussion
Use values in calculated column without summarization
Hi,
I'd like to use the values in a calculated column as values in a visual (Y axis). These columns are set to "Don't summarize" in the Table view (check screenshots).
Every time I try to add them to a visual, it shows no data and tries to summarize the columns. Even if the option "Don't summarize" is not there if I right-click.
How can I use these values in visuals? Any help would be appreciated.
Regards,
Gabriel Crespo
Hi,
Here are the 2 changes i carried out.
- Dragged Name from the Tactics table (rather than Tactics from the techniques table)
- Changed the summarisation function to sum
Hope this helps.
12 Replies
You are using a custom visual. Ask the developer of the visual for advice.
Hi again,
The problem doesn't look to be related with the specific visual (of course, I had tried with a bunch of them before asking here). The same thing happens with a standard visual:
Any help would be greatly appreciated.
Regards,
Gabriel Crespo
can you provide a sample pbix that illustrates the issue?
A column chart visual requires aggregation over the Y axis. I changed the visual to Table and the column is showm without aggregation.
Hi Ibendlin,
Thank you, but I'm afraid that's not the point. The point is why can't I use a measure in the Y axis? I have previously calculated that aggregation myself. I need to show the following values:
Number of Techniques with CdU / Total number of techniques * 100 (percentage)
this is to show the coverage of Techniques I have over the total number of them. And this has to be done grouped by Tactic (That's why I was using a radar chart). Honestly, it's nonsense I cannot use a INTEGER value in a Y axis!!!
Regards,
Gabriel Crespo
Hi,
Here are the 2 changes i carried out.
- Dragged Name from the Tactics table (rather than Tactics from the techniques table)
- Changed the summarisation function to sum
Hope this helps.
Hi Ashish Mathur,
Thank you for that, however, I'm afraid that's not solving the problem. I need to know why I can't use an INTEGER value in a Y axis.
Regards,
Gabriel Crespo
