Don't miss your chance to take the Fabric Data Engineer (DP-700) exam on us!
Learn moreNext up in the FabCon + SQLCon recap series: The roadmap for Microsoft SQL and Maximizing Developer experiences in Fabric. All sessions are available on-demand after the live show. Register now
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 🙂
If you have recently started exploring Fabric, we'd love to hear how it's going. Your feedback can help with product improvements.
A new Power BI DataViz World Championship is coming this June! Don't miss out on submitting your entry.
Share feedback directly with Fabric product managers, participate in targeted research studies and influence the Fabric roadmap.
| User | Count |
|---|---|
| 48 | |
| 45 | |
| 41 | |
| 19 | |
| 17 |
| User | Count |
|---|---|
| 68 | |
| 68 | |
| 33 | |
| 31 | |
| 31 |