Forum Discussion
Microsoft EmployeeShare your thoughts on visual calculations (preview)
I have couple of thoughts on Visual calculations:
1. How to use Visual Calculations with Field Parameters. I want to enable some calculations on visual based the selected value in field parameter. For example: I have a,b,c and d visual calculation on visual. I have setup a field parameter with slicer values a,b,c and d.
So when a user select a and c from the slicer, user should see respective columns on visual.
2. How it will work with matrix visual with nested columns. For example in below table i have Sales and Qty numbers for FY and FY-1 and i want to get (FY) + (FY-1) using visual calculations that would sum up the values of Sales and Qty for FY and FY-1. Is this currently supported?
| FY | FY-1 | (FY) + (FY-1) | ||||
| Country | Sales | Qty | Sales | Qty | Sales | Qty |
| India | 43 | 5345 | 34 | 34 | 77 | 5379 |
| China | 545 | 64 | 545 | 64 | 1090 | 128 |
| USA | 34 | 43 | 34 | 34 | 68 | 77 |
| France | 6 | 645 | 64 | 43 | 70 | 688 |
| Germany | 46 | 454 | 34 | 54 | 80 | 508 |
Microsoft Employeehello, field parameters are not supported at this time.
What are your thoughts about point 2?
jeroenterheerdt- jeroenterheerdt
you should be able to do this with expand / collapse. Documentation is still being published for those.