Starting December 3, join live sessions with database experts and the Microsoft product team to learn just how easy it is to get started
Learn moreGet certified in Microsoft Fabric—for free! For a limited time, get a free DP-600 exam voucher to use by the end of 2024. Register now
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:
In my sample pbix (click to download from my GDrive), I connected to the Ofeed data from powerbi.tips (click for the link to the webpage)
http://services.odata.org/AdventureWorksV3/AdventureWorks.svc
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.
Proud to be a Super User!
I found this concept very helpful! I will add that: if you have many categories that identify each row, keep as many of them as possible in your "Category" table. Thanks @danextian !
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.
thx,
M
Can you send pbix file for the same..
Thanks...
Hi @punit
The link to pbix is in my original post. It's publicly downloadable from my Google Drive.
Proud to be a Super User!
Can you share pbix file for the same...
Thanks
my problem is solved, what problem you are facing.
REGARDS...
WAQAR
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,
WAQAR...
+92 333 3035810
Hi,
What did you use to create the 4 interactive tiles on top of your dashboard. Thanks
Hey @tmaz1234,
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.
Cheers
Well done!
Kudoed as commanded 😉
Starting December 3, join live sessions with database experts and the Fabric product team to learn just how easy it is to get started.
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount! Early Bird pricing ends December 9th.
User | Count |
---|---|
90 | |
86 | |
83 | |
64 | |
49 |
User | Count |
---|---|
127 | |
108 | |
88 | |
70 | |
66 |