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

Get inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.

Reply
Anonymous
Not applicable

SSRS Matrix chart to Power BI

Hi All.

 

I am migrating SSRS report into Power BI, i am facing below challenges for the drill down & drill up format and another is spliting column headers based on measure values. For the second screen shot when i drag and drop the one column header it is not showing the specific columns for example in my case 4 measures, it is taking all the 12measure values into it. I want to split into 3 Column headers*5 Columns=15

 

image.png

 

image.png

 

1 REPLY 1
v-shex-msft
Community Support
Community Support

Hi @Anonymous,

 

I can't get something useful from your snapshots, can you please share some detail information?

How to Get Your Question Answered Quickly

 

In addition, you can also take a look at following blog about get current row contents.

Using the SELECTEDVALUE function in DAX

 

Regards,

Xiaoxin Sheng

Community Support Team _ Xiaoxin
If this post helps, please consider accept as solution to help other members find it more quickly.

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!

FebPBI_Carousel

Power BI Monthly Update - February 2025

Check out the February 2025 Power BI update to learn about new features.

March2025 Carousel

Fabric Community Update - March 2025

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