Need help on the below request

[francisjohn83]

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.

[v-cgao-msft · Accepted solution]

Hi @francisjohn83 ,

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

[foodd]

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?

[francisjohn83]

Here I don't do any aggregation ?

[mussaenda]

Hi @francisjohn83 ,

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