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
PBI_APRIL_CAROUSEL1

Power BI Monthly Update - April 2024

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