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
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
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.