Help about Table in Power BI

Hi Syndicate_Admin ,

Based on the screenshot you provided, I can't confirm how your data structure is constructed. As I understand it in the screenshot on your power bi, the last two columns seem to be a MEASURE, however a MEASURE is a logic that calculates in a row context environment, and your front category is what defines how your calculations are done according to the category. Of course you can try to change this by using a matrix visual object where the values are constrained by your rows and columns, for example you could put your category in the rows, your year in the columns, and the measure you created in the values, and of course you could pivot on the dates if you wanted to implement this in a table.
If the above methods can not solve your problem, please provide detailed example data, including but not limited to the data structure, the formula of the measure, etc., please hide in advance, sensitive information, so that we can better help you.

Best regards,

Albert He

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly

Repeating the same data in the same visual is a design red flag.  Use separate visuals.

Hello

The table is as follows

I still need to be able to place the year as it appears, since I was already able to solve the last columns