Can't add value field to "Values" in visual

[Anonymous]

Below is a link to a .pbix file with a super simple table with Account, Date, Amount and a calculation group with a QTD calculation. Why can't I add a value field to the matrix visual? Everything in my other models worked fine until I tried to add calculation groups. What am I missing?

https://ufile.io/2hdb2akl

Thanks,

Eric

[Josh_N]

I came accros this as well.  Spent hours trying to figure out why I could not get box & whisker or violin visuals working.  Deleted the calculation groups I had created and everying popped up.

[rbriga]

I have been trying to understand why box & whisker \ violin won't show up, too.

Your comment saved me.

[v-lionel-msft]

Hi @Anonymous ,

It may be because this field is not aggregated, but I am not sure what limitation is causing this problem, you may need to check your M code.

You can create a measure and add it to the matrix.

Measure = SUM(Table1[Amount])

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[Anonymous · Accepted solution]

Lionel, 

I learned that intrinsic measures (identified by the summation sign) cannot be aggregated in calculation groups.

This is why I need to create a measure for the data. Thanks to Patrick at Guy in a Cube for the explanation. Check out his answer to this question at https://www.youtube.com/watch?v=1LBgvVn2PVo beginning at minute 0:41:04. 

[Anonymous]

@v-lionel-msft, thanks so much for the response. I am wondering why aggregation on the column is lost when I add a calculation group to the model. I have not been able to re-add the aggregation once it disappears. 

Here is my M code:

let
Source = Excel.Workbook(File.Contents("C:\Users\enyberg\Desktop\Sample data.xlsx"), null, true),
Table1_Table = Source{[Item="Table1",Kind="Table"]}[Data],
#"Changed Type" = Table.TransformColumnTypes(Table1_Table,{{"Account", type text}, {"Amount", type number}, {"Date", type date}})
in
#"Changed Type"

Does anything look problematic in the code?

Thanks!

Eric

[v-lionel-msft]

Hi @Anonymous ,

Very strange, I can't find the cause of this problem in Power BI Desktop, it seems that there is no problem everywhere, maybe it is the problem of the data source, try to check the data source and refresh the dataset.

Best regards,
Lionel Chen

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vanessafvg]

what are you trying to do exactly? its not clear from your model, what is clear is that between your date table and your data table there is no relationship.

[Anonymous]

There is no date table, hence no relationship. I was trying to eliminate as many variables as possible to isolate the issue. I just want the "Amount" values to appear in my visual (not as a row or column header, but as values).

[vanessafvg]

its really hard to help you without you sharing all the data and b providing an example of what your are expecting.

there are too may scenarios, if you need help you need to give all the information.

What headers do you want in place of the value? So if you want to say what type of account it is, you will need to create each measure for that by doing something like
expenses = calculate(sum(amount), account = "Expense")

[Anonymous]

Sorry to be confusing. Below are links to two .pbix files. The first link is a model that includes the visual as I want it to appear. What steps do I need to take to make visual in the second link to look like the visual in the first link?

First link: Before group calculation

https://ufile.io/jf8y1e3t

Second link: After group calculation

https://ufile.io/jubbg0ee

Thanks,

Eric