Use values in calculated column without summarization

[gcrespo]

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

[gcrespo]

Hi,

Please, follow the link to my Google Drive 

Regards,

Gabriel Crespo

[Ashish_Mathur · Accepted solution]

Hi,

Here are the 2 changes i carried out.

1. Dragged Name from the Tactics table (rather than Tactics from the techniques table)
2. Changed the summarisation function to sum

Hope this helps.

[gcrespo]

Hi again,

I've been investigating and it looks like what I'm looking for will not be possible. Your answer works and provides the same output I was looking for.

Thank you and regards,

Gabriel Crespo

[gcrespo]

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

[lbendlin]

A column chart visual requires aggregation over the Y axis.  I changed the visual to Table and the column is showm without aggregation.

[gcrespo]

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

[lbendlin]

You cannot measure or aggregate a measure. Incorporate your complete loginc in a single measure.

[gcrespo]

Hi Ibendlin,

But all my logic is implemented in my calculated column, and I can't use it in the visuals. That's the point here.

Regards,

Gabriel Crespo

[lbendlin]

But all my logic is implemented in my calculated column, 

How are your users supposed to interact with your report?

Please provide sample data (with sensitive information removed) that covers your issue or question completely, in a usable format (not as a screenshot). Leave out anything not related to the issue.
https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...
Please show the expected outcome based on the sample data you provided.

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/m-p/1447...

[gcrespo]

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

[lbendlin]

can you provide a sample pbix that illustrates the issue?

https://community.fabric.microsoft.com/t5/Community-Blog/How-to-provide-sample-data-in-the-Power-BI-...

[lbendlin]

You are using a custom visual. Ask the developer of the visual for advice.