Most of the time, I post on the community to ask for help but this time I am giving back.
I've read several posts that dynamic category based on slicer selection is not possible. While it may not be an out of the box feature, it is possible with some tweaking. I've also read similar solutions but I find mine simpler and easier to follow :). The trick makes use of the following:
and used CompanySales table.
Here are the steps,
You may view my sample report here:
Please don't forget to kudos this post if you find this helpful.
I managed to reproduce this today - great tool and an elegant solution, thanks!
I wonder: did you ever try to combine two identical and interdependent of these into one page? I failed, cause they block each other.
The link to pbix is in my original post. It's publicly downloadable from my Google Drive.
i preapred a KPI dashbaord and use below KPI tile,i need to cummualtive monthly value in quarter via slicer to show respective data in KPI tile.
Can anybody help me out in this regards,
+92 333 3035810
the interactive tiles are "just" a slicer with a horizontal layout. Go to the General Format options of the slicer and switch the orientation to horizontally.
Power Platform release plan for the 2021 release wave 2 describes all new features releasing from October 2021 through March 2022.
Click here to read more about the July 2021 Updates
Did you know that you can visit the Power Query Forum in Power BI and now Power Apps
Dont miss our very own April Dunnam’s The Developer Guide to the Galaxy! Find out what the Power Platform has to offer for the traditional developer.