The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi
I have a matrix visual that shows SUM of values contained in a table column PAYMENT - NET in columns segmented by tabel column SEASON. I separated the matrix into rows by values in the table column PAYMENT.
I use a filter to filter the visual by values in the table column ORGANIZATION.
I would like to add a variance between the SUM of the PAYMENT - NET values that displays the percentage variance between SEASON.
I am including a sample table for reference and a screenshot of the current table and where I would like to add the variance column
Thanks for your help. Been struggling with this for a day and can't find an example of a similar issue.
Hi @Marks9172
Can you provide some sample data to help you on this
I would suggest, create measures for each segment like "21/22" and "22/23", then calculate variance between these two measures
Also realized it might be helpful to have an image for the setup of the matrix visual