Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
2 years ago
Solved

Need help on the below request

Hi,

 

The below mentioned image will represent 2 columns, You can see DG-20230511-40 contains class types - 3 ,8, 9. How should i make it in this following report for the DG-20230511-40 I would like to show all the respective classes in another row by 3,8,9 not by each row.

 

 

Need Help
Show and Tell

4 Replies

  • mussaenda's avatar
    mussaenda
    Community Champion
    2 years ago

    Hi Anonymous ,

     

    if you are looking for a power query solution, you can group your data according to the DG column 

  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Here I don't do any aggregation ?

  • foodd's avatar
    foodd
    Community Champion
    2 years ago

    Would you please add more information to clarify the question you have, and also add a mockup of your desired results.   Please mock up the whole page and include any slicers and other visuals on the page. 

     

    The business logic, designs of powerquery-m, and DAX probably will come up in this conversation, so please be prepared to attach a sample Power BI Desktop file as well as any related source data in Excel format. 

     

    Question:

     

    • How are you currently reporting on this data, and what upstream source or sources are involved?   
    • What type of model will this be? 
    • Will it be set up using Direct Query or Import or other?   
    • Will this be published on the Web or Report?
    • Is RLS or OLS involved?
  • Anonymous's avatar
    Anonymous
    Not applicable
    2 years ago

    Hi Anonymous ,

    PQ:



    Dax:

     

    Please check the pbix file.

     

    Best Regards,
    Gao
    Community Support Team

     

    If there is any post helps, then please consider Accept it as the solution  to help the other members find it more quickly. If I misunderstand your needs or you still have problems on it, please feel free to let us know. Thanks a lot!

    How to get your questions answered quickly --  How to provide sample data in the Power BI Forum