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

Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.

Reply
data142536
Frequent Visitor

Display new column from field parameters in matrix rows and not in columns

Hi I have a table with ticket Id, Created date, closed date. I have two measures - CreatedTickets and Closed Tickets. I created a field parameter table like below where KPI is just =Parameter. I also have a new calculated column called "Goal"

data142536_0-1690325914143.png

 

I want to create a matrix visual to display KPI, Goal in rows, month in columns and value in values

but the problem is the KPI is showing in both rows and columns,

data142536_1-1690326192698.png

 

is there a way to show KPI and goals only in rows? Columns should just include month-year

here's the expected result.

data142536_2-1690327221006.png

 

I was able to achieve it using selectedvalue but this doesn't meet my usecase because I want to do conditional formatting only for one KPI (selected value doesn't show individual KPIs in cell elements under formatting)

 

 

Please help me/ let me know if I am missing anything

 

1 ACCEPTED SOLUTION
data142536
Frequent Visitor

was able to solve this using selectedvalue measure

View solution in original post

2 REPLIES 2
data142536
Frequent Visitor

was able to solve this using selectedvalue measure

data142536
Frequent Visitor

sample pbix here - test.pbix

Helpful resources

Announcements
RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

Ask questions in Eventhouse and KQL, Eventstream, and Reflex.

MayPowerBICarousel

Fabric Monthly Update - May 2024

Check out the May 2024 Fabric update to learn about new features.

LearnSurvey

Fabric certifications survey

Certification feedback opportunity for the community.