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.
Hi,
Being a newbie requesting help to get the aggregated values below the "total" row generated from TABLE visual. Unable to use MATRIX visual as i need to show the aggregated values below the total(sample representation as below).Will use the same for Date wise as well as month wise ,year wise slicer.
Data Set Sample as below:
Also i have created Aggregated Table using Power query which is available as a data set:
Also have created measures on values for each measuing point separately which is used for other graphical visuals.
Deeply appreciate forums support to meet the objective. Thank you.
Solved! Go to Solution.
Hi @InsHunter ,
Which custom visual you are creating? Is it Inforiver Enterprise Matrix / Table? If yes, you can see the option "Insert" just as below screenshot.
And you can try the other methods which I refer in my previous post:
By using ROW function:
Add new row with accumulate in Matrix
Table = UNION(VALUES('Sales'[Product]),ROW("Product","XMonth Accumulate"))
Looking for difference between two values by filters
Best Regards
Hi @InsHunter ,
Please review the following links and check if they can help you get one solution:
1. Create Inforiver visual:
Insert row and manually enter data in Power BI matrix reports
2. By using ROW function:
Add new row with accumulate in Matrix
Table = UNION(VALUES('Sales'[Product]),ROW("Product","XMonth Accumulate"))
Looking for difference between two values by filters
Best Regards
Hi,
Thanks for the same. I tried the custom visual but the "Insert Row" is not being shown when I select this visual.
Thanks
Hi @InsHunter ,
Which custom visual you are creating? Is it Inforiver Enterprise Matrix / Table? If yes, you can see the option "Insert" just as below screenshot.
And you can try the other methods which I refer in my previous post:
By using ROW function:
Add new row with accumulate in Matrix
Table = UNION(VALUES('Sales'[Product]),ROW("Product","XMonth Accumulate"))
Looking for difference between two values by filters
Best Regards
@InsHunter , You can not add additional totals, but you can have min/max using isinscope
if(not(Isinscope(Table[Date])) , [Max Meausre], [Measure])
https://www.kasperonbi.com/use-isinscope-to-get-the-right-hierarchy-level-in-dax/
@amitchandak
Hi. Thanks for your response. If further support can be given it will be helpful as i could not make much out of this. Deeply appreciate your help.
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 |
---|---|
42 | |
21 | |
21 | |
14 | |
13 |
User | Count |
---|---|
43 | |
36 | |
33 | |
18 | |
18 |