Earn a 50% discount on the DP-600 certification exam by completing the Fabric 30 Days to Learn It challenge.
I'm new to Power BI but have to use it in my master's thesis to create a benchmarking dashboard.
Here's my issue:
It is essential for the user to be able to select one company, that is the focus of the analysis (Benchmarked Company)
Further, one has to be able to select one or multiple comparison companies, that will be compared to the first selected company.
But I am unable to do this properly.
>>> HERE IS THE POWER BI FILE <<<
--
Here is what I did so far:
Second Try:
As I was not able to put two slicers on the same column (Company) in a senseful manner I did the following: I duplicated the table with all the data and now I have
But now I can't get Power BI to return all the companies (The one Benchmarked Focus Company AND the multiple Peer Companies) in a single list.
(PS: First Try:
One Table with One Slicer to select the companies. However, I was unable to then differentiate between Benchmarked Company and Peer Companies. )
I kindly ask for help as I am getting crazy about this and I have to hand the thesis in soon.
Solved! Go to Solution.
Within same chart, the selection you made in slicer will be applied as filter context on all data fields within this visual. It's not possible to have a measure take the context from slicer1 and another same measure takes the context from slicer2. And when you select multiple items in slicer2, their corresponding data must be aggregated.
In your scenario, I don't think it's significant to include the Benchmarked Company data (for example, sales) and the comparison data (let's say, the difference between peer company sales and Benchmarked Company sales) into same chart. I think your first approach looks more friendly. Just put the company into Legend, each selected companies' sales data will be displayed. And you can "fix" a specific color for Benchmarked Company data.
If you must show the difference value in the line chart. You have to "fix" this Benchmarked Company sliced measure value into a calculated column into your source table. Then you can directly compare this value under any context.
Regards,
Within same chart, the selection you made in slicer will be applied as filter context on all data fields within this visual. It's not possible to have a measure take the context from slicer1 and another same measure takes the context from slicer2. And when you select multiple items in slicer2, their corresponding data must be aggregated.
In your scenario, I don't think it's significant to include the Benchmarked Company data (for example, sales) and the comparison data (let's say, the difference between peer company sales and Benchmarked Company sales) into same chart. I think your first approach looks more friendly. Just put the company into Legend, each selected companies' sales data will be displayed. And you can "fix" a specific color for Benchmarked Company data.
If you must show the difference value in the line chart. You have to "fix" this Benchmarked Company sliced measure value into a calculated column into your source table. Then you can directly compare this value under any context.
Regards,
Thank you!
User | Count |
---|---|
102 | |
90 | |
80 | |
71 | |
70 |
User | Count |
---|---|
114 | |
100 | |
97 | |
72 | |
68 |