Microsoft Fabric Community Conference 2025, March 31 - April 2, Las Vegas, Nevada. Use code FABINSIDER for a $400 discount.
Register nowGet inspired! Check out the entries from the Power BI DataViz World Championships preliminary rounds and give kudos to your favorites. View the vizzies.
Hello,
I am having a problem with meeting below requirement:
I have a below data set:
Product Name | Type | Value bmk | valu rtrn |
Strategy Name 2 | Strategy | 12 | 18.46667 |
Strategy Name 1 | Strategy | 18.46667 | 12 |
Strategy Name 0 | Strategy | 34 | 12 |
Strategy Name 3 | Strategy | 12 | 7.688889 |
Product 5 | Product | 23 | 4.455556 |
Product 6 | Product | 12 | 1.222222 |
Product 7 | Product | 18.46667 | -2.01111 |
Product 8 | Product | 18.69524 | -5.24444 |
Product 9 | Product | 18.92381 | -8.47778 |
Product 10 | Product | 19.15238 | -11.7111 |
Product 11 | Product | 19.38095 | -14.9444 |
Product 12 | Product | 19.60952 | -18.1778 |
Product 13 | Product | 19.8381 | -21.4111 |
Product 14 | Product | 20.06667 | -24.6444 |
Data should be shown on a scatter chart, like on a screenshot below.
The issue i am facing is to have a slicer at the top. in slicer we want to show product names, where type = strategy.
When Particular Strategy is selected we want to show values associated with the selected strategy (Strategy 0 according to screenshot) and alll values associated with a products.
In scenario presented on a screenshot we want to show all data from the table except Strategy Name 1, Strategy Name 2, Strategy Name 3, but it should be dynamic and driven by a slicer selection.
Will be grateful if somebody can quide me how to build a proper dax syntax.
Thanks in advance.
Solved! Go to Solution.
Awesome, thanks 🙂
March 31 - April 2, 2025, in Las Vegas, Nevada. Use code FABINSIDER for a $400 discount!
Check out the February 2025 Power BI update to learn about new features.
User | Count |
---|---|
126 | |
113 | |
69 | |
59 | |
46 |