KPI Table - Filter row metrics based on column date intervals

[Anonymous]

I'm trying to create a KPI table that has two row dimensions: Store and KPI. Each column represents a different time slice (Current Day/MTD/YTD/etc) and I'm trying to have the KPI filter based on the date filter in the column. Is something like this possible?

I have a ton of KPIs and I really don't want to overwhelm the visualization by having "Revenue Current Day/Revenue WTD/Revenue MTD/etc" calculations be individual columns. 

[v-xulin-mstf]

Hi @Anonymous

Sorry, i'm not sure about your expected output.

Could you provide more details?

Please see this post regarding How to Get Your Question Answered Quickly:
https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[v-xulin-mstf]

Hi @Anonymous

Is your issue solved?

If the issue has been solved, please share the solution and adopt it to help others.

Thanks! 😉

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[dkaushik]

Hi @Anonymous ,

This type of layout is possible.
Use a "Matrix" visual. Put your "Store" and "KPIs" under Row headers. Use your all the measures in Values field. Then go to formatting, under row headers turn off "Stepped layout" option and also disable the "+/- icons".

If this post helps, then please consider Accept it as the solution and give thumbs up to help the other members find it more quickly.

Thanks,

Dheeraj

[Anonymous]

The problem is that my KPIs are my measures. For example, Revenue is a SUM off a SQL table, and if I want a MTD revenue figure I have to create a separate measure that filters the original Revenue measure, but that's what I'm trying to avoid.