Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
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?
Thanks,
Eric
Solved! Go to 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.
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.
I have been trying to understand why box & whisker \ violin won't show up, too.
Your comment saved me.
Hi @enyberg ,
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.
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.
@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
Hi @enyberg ,
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.
Proud to be a Super User!
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).
Proud to be a Super User!
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
Second link: After group calculation
Thanks,
Eric
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
115 | |
99 | |
86 | |
70 | |
62 |
User | Count |
---|---|
151 | |
120 | |
103 | |
87 | |
68 |