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

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

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
Anonymous
Not applicable

was able to solve this using selectedvalue measure

View solution in original post

2 REPLIES 2
Anonymous
Not applicable

was able to solve this using selectedvalue measure

Anonymous
Not applicable

sample pbix here - test.pbix

Helpful resources

Announcements
Europe Fabric Conference

Europe’s largest Microsoft Fabric Community Conference

Join the community in Stockholm for expert Microsoft Fabric learning including a very exciting keynote from Arun Ulag, Corporate Vice President, Azure Data.

Power BI Carousel June 2024

Power BI Monthly Update - June 2024

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

RTI Forums Carousel3

New forum boards available in Real-Time Intelligence.

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