Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
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
Solved! Go to Solution.
was able to solve this using selectedvalue measure
was able to solve this using selectedvalue measure