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

[Anonymous]

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"

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,

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

here's the expected result.

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

[Anonymous · Accepted solution]

was able to solve this using selectedvalue measure

[Anonymous]

sample pbix here - test.pbix