Register now to learn Fabric in free live sessions led by the best Microsoft experts. From Apr 16 to May 9, in English and Spanish.
Hello all,
I want to create a slicer/filter based on the different columns in the dataset and use that custom filter on other visualizations.
For eg: my dataset looks like this:
ID Impressions Likes Shares Posts
1 1213 12 10 40
2 13121 1213 40 100
Total Likes: 1225
Total Shares: 50
Total Posts: 140
I want a custom filter with these 3 values to choose from: 1) Total Likes 2) Total Shares 3) Total Posts
The chosen filter value will be then used as a text on display or maybe in some other monthly trend visualization. I know that creating a calculated measure may be the way but don't know the next steps. Any assistance will be highly appreciated!!
Solved! Go to Solution.
Hi @Anonymous,
Welcome to the boards! Just so your're aware, if you post questions related to modelling in either the Desktop or DAX forums rather than this one, there's a lot more traffic there and a lot more ready assistance. This particular forum (Custom Visuals Development) is concerned with using software development tools to extend Power BI's visuals and doesn't get as much traffic as some of the others. This may help direct you if you have further questions like this one, as you can get faster help in future 🙂
Presuming I've understood correctly, you want something like this?
If so, here's a simple workbook with your sample data mocked-up, and the measures and additional modelling to do it.
This requires the use of a disconnected table. I'm not going to specifically go into the concept too much, as it's covered in more detail (and better then I can) here:
I've uses the techniques in this post to create with your data, so hopefully you'll find useful. fourmoo are one of many incredible community resources for Power BI so are worth following in general if you're not aware of them.
Good luck!
Daniel
If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hi @Anonymous,
Welcome to the boards! Just so your're aware, if you post questions related to modelling in either the Desktop or DAX forums rather than this one, there's a lot more traffic there and a lot more ready assistance. This particular forum (Custom Visuals Development) is concerned with using software development tools to extend Power BI's visuals and doesn't get as much traffic as some of the others. This may help direct you if you have further questions like this one, as you can get faster help in future 🙂
Presuming I've understood correctly, you want something like this?
If so, here's a simple workbook with your sample data mocked-up, and the measures and additional modelling to do it.
This requires the use of a disconnected table. I'm not going to specifically go into the concept too much, as it's covered in more detail (and better then I can) here:
I've uses the techniques in this post to create with your data, so hopefully you'll find useful. fourmoo are one of many incredible community resources for Power BI so are worth following in general if you're not aware of them.
Good luck!
Daniel
If my post solves your challenge, then please consider accepting as a solution to help other forum members find the answer more quickly 🙂
Proud to be a Super User!
My course: Introduction to Developing Power BI Visuals
On how to ask a technical question, if you really want an answer (courtesy of SQLBI)
Hey Daniel,
This is fantastic, exactly what is was looking for. Thanks a lot for your time and effort to this solution.
And thanks for the advice to post relevant posts under relevant sections for more viewability. Will surely follow the same!
Thanks
Shubham
Covering the world! 9:00-10:30 AM Sydney, 4:00-5:30 PM CET (Paris/Berlin), 7:00-8:30 PM Mexico City
Check out the April 2024 Power BI update to learn about new features.
User | Count |
---|---|
5 | |
1 | |
1 | |
1 | |
1 |