Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.

Reply
francisjohn83
Frequent Visitor

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.

 

francisjohn83_0-1693305250023.png

 

1 ACCEPTED SOLUTION
v-cgao-msft
Community Support
Community Support

Hi @francisjohn83 ,

PQ:

vcgaomsft_0-1693463974626.png

Dax:

vcgaomsft_1-1693464116376.png

 

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

View solution in original post

4 REPLIES 4
v-cgao-msft
Community Support
Community Support

Hi @francisjohn83 ,

PQ:

vcgaomsft_0-1693463974626.png

Dax:

vcgaomsft_1-1693464116376.png

 

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
Super User
Super User

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
Frequent Visitor

Here I don't do any aggregation ?

mussaenda
Super User
Super User

Hi @francisjohn83 ,

 

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

Helpful resources

Announcements
Microsoft Fabric Learn Together

Microsoft Fabric Learn Together

Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City

PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

Check out the April 2024 Power BI update to learn about new features.

April Fabric Community Update

Fabric Community Update - April 2024

Find out what's new and trending in the Fabric Community.

Top Solution Authors
Top Kudoed Authors