Forum Discussion
Advice on Comparison Dashboard
Hi there, and thanks for checking out this post.
I am building a tool to compare different technologies and having some issues with images and chart visualistions.
I have uploaded my dashboard here: https://we.tl/t-RrMb0ZZ47p
At the top I have two "global" slicer that should affect everything below. They seem to work - Product Type, Product Size.
Then on the left I have diesel data, coming from a table called Diesel Vehicles, and on the right I have Battery ELectric, from a table called BEV Vehicles.
The slicers in these both called Product Name, again, these seem to work OK.
Below this I have two image boxes that should show the image of the models selected. This works a bit... if either of the slicers has a model selected it works, but if they are both selected, they go blank. They should not be interacting with the opposing slicers at all, so not sure why they are not working independently.
The next issue is I want to compare specific characteristics against eachother in the graph at the bottom, but it seems to work OK if just one model is selected, but not both. I assume this is the same issue.
Any help would be appreciated.
Have I set the data up in a sensible way? Thanks!
Hi Luca - the spreadsheet I originally uploaded had the layout I have planned, and hopefully the functionality can be made to work. On the file you uploaded I can only select a single model vehicle.
Here is how I would like it to look:
Sorry if I am being confusing, I am certainly confused.
Here the link:
https://we.tl/t-pxaAicF8t8
Two solution:
Page 1
Multiple slicer with a single Visual
Page 2
A table that can show also more than 2 veichles.
You have to work with the visual filter specific for the single visual.
And also with the interaction (some slicer doesn't have to work on specific visual).
I hope i'll be helpfull.
Mark as a solution if i resolve your problem.
8 Replies
lucadelicioImpactful Individual
The relationship between the 2 tables has no sense. You connect the EV with the DV- on the number of veichles? Why?
You have to create a new table that is the merge of the two.
With power query in the transform data.
So every common field where be in union and every specific common where adding in a specific column.
First step it will be to delete the relationship.
If you upload also the excel dataset i will set for you.
Let me know.- lucadelicio
Here the link:
https://we.tl/t-AIqHleD4Nj
To open correctly the file you have to enter in the pwoer query transform data and set the path from the file excel it will be taken.
On transform data:- I add a column Type to both table to describe if is BEV o DIESEL.
- I enable the import of the 2 table.
- I create a new table with the append of the previous two tables and import only this tableNow you have only one table on the model with the specific of veichle type and your slicer will be ok.
Let me know if i resolve your problem.
Mark it as a solution if i resolve your problem.
Ciao!Hi there, thanks for the help, but now there is only a single column with data from both BEV and Diesel models.
I need a slicer on the left with just Diesel models and one on the right with just EV models, and the graph below, comparing the two in a particular field.
That is why I originally had two tables, though I can see that the relationships didn't make sense.
- lucadelicio
Now you have the entire dataset.
If want to compare something put a table with in the column the Type and in the rows what you want to compare... So the extract the values for both the type...
You have to explain EXACTLY what you want, better if with an image.
Yes - sorry I am totally new to this, I tried it once with just a single table, but the slicers seemed to interact with eachother despite them being set not to interact. So this is attempt two.
Here is the Excel data.
Do you create the merged table in Power BI or Excel? Thanks for the help!