Forum Discussion

Utilisateur_pb's avatar
Utilisateur_pb
Helper I
1 year ago

Table columns format

Hi everyone,

I write this message, to ask for suggestions concerning my demand.

I want to create a table like this :

 

But i couldn't do it with what powerBI offers: I used the matrix and i couldn't do it what i want is just the first measure from the first column (with year 2023) below and all the measures under the second column with year 2024

 

Don't hesitate to suggest me solutions to show my table as i want .

Best regards.

General Comment
Interesting Links
Need Help
Show and Tell
Tips and Tricks

3 Replies

  • djurecic's avatar
    djurecic
    Super User
    1 year ago

    Hi Utilisateur_pb ,

     What measures have you created for years 2023 and 2024? Are you using a date table? You can create measures for a specific year using Calculate and Filter.

    • Utilisateur_pb's avatar
      Utilisateur_pb
      Helper I
      1 year ago

      Hi, thank you for your response.

      I created the measures that calculate the charges for the year selected and the year before and the gap between the two. The thing is it will be automated every year, i want to show the actual year and the year before, and i can't do this with measure, because its name can't be automated to change years.

       

  • Anonymous's avatar
    Anonymous
    Not applicable
    1 year ago

    Hi Utilisateur_pb ,

     

    Could you please provide more details? Such as demo pbix file (does not contain sensitive data). That will help us understand the problem better.

     

    Thanks for djurecic reply.

     

    Best regards,

    Mengmeng Li