Results 1 to 3 of 3

Thread: Adding multiple columns in Matrix columns
Thanks Thanks: 0 Likes Likes: 0

  1. #1
    New Member
    Join Date
    Jul 2019
    Posts
    4
    Post Thanks / Like
    Mentioned
    1 Post(s)
    Tagged
    0 Thread(s)

    Default Adding multiple columns in Matrix columns

    Hi All,

    I am new to power BI and I have requirement to do in power BI where I need to show the some of key metrics in matrix format.

    Here is the my requirement.
    Well I am working for the Textile company where in I need to prepare the reports using Power BI and unfortunately I could not make it. I use matrix for the showing the differences of reports between 2018 and 2019.


    Please check the below screen shot where I need to get the output like mentioned screenshot.




    Please note that %Change in the above table is a measure which I had written
    % change = DIVIDE(CALCULATE(SUM(Table1[Reports]),Table1[Year]=2019)-CALCULATE(SUM(Table1[Reports]),Table1[Year]=2018),
    CALCULATE(SUM(Table1[Reports]),Table1[Year]=2018))


    When I am trying to add the same measure in my matrix the % change showing
    for the both 2018 and 2019 years and I need it at the end of matrix.


    You may check the my visualization pane to verify the rows and columns.



    Is there any work around for the same issue and I've trying it

    for a long time and finally seeking for your help.


    Thanks for your help
    0 0
     

  2. #2
    Board Regular sandy666's Avatar
    Join Date
    Oct 2015
    Posts
    2,818
    Post Thanks / Like
    Mentioned
    32 Post(s)
    Tagged
    1 Thread(s)

    Default Re: Adding multiple columns in Matrix columns

    I know you know but I forgot my Crystal Ball and don't know what you know



    In the first post, show the type of machine (PC / Mac) and the Office version you are working on
    impossible things we do on the spot. for miracles you need to wait for a while
    0 0
     

  3. #3
    MrExcel MVP
    Moderator
    Fluff's Avatar
    Join Date
    Jun 2014
    Location
    Chippenham
    Posts
    28,120
    Post Thanks / Like
    Mentioned
    470 Post(s)
    Tagged
    47 Thread(s)

    Default Re: Adding multiple columns in Matrix columns

    @Sandeep3072
    Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread.
    Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).
    - Posting Data try one of these tools
    - Posting guidelines, forum rules and terms of use
    - Read the FAQs

    Running Office 365 on Win 10
    0 0
     

Some videos you may like

User Tag List

Tags for this Thread

Like this thread? Share it with others

Like this thread? Share it with others

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •