Subtotal Column That Displays in Context of Slicer
I'm trying to create a subtotal column I can use in operations with other columns. In the example below, I have used REMOVEFILTERS for the Subtotal column, but it obv stays constant despite any filtering. Needs: Subtotal always shows the total value in context of applied slicers, but the table itself should show row level Date, Location, ID, and value. Given the below image, a location slicer would adjust the subtotal and the weight (Value/Subtotal) of all dates, and IDs for that location. Similarly, a date slicer would adjust these as well. if 1/3/2022 is selected, the subtotal will be a sum of all values for just that day, and then calculate the weight based on the row's value against the subtotal of all locations/ids for that day.Is it possible to change the names of the subtotal and total in the Table Matrix?
Dear Community, amitchandak If have created a structure of cost types to use in a Matrix visual in Power BI. No wI want to change the names of the subtotal and total in the Table Matrix. 1. Is this possible like in the picture below 2. Is it also possible to choice which subtotal you want to show? Like in the picture below? Is there a custom visual available which can do this? Becasue the dfault matrix visual is not able to do these 2 things Kind regards, louis van Paassen
