I'm trying to switch over from Tableau because of some limitations in the software, but when I pick a viz software, a key element is that the end user can interact with my final outputs. This includes not just filtering, but also choosing what fields to see on a chart and the ability to drill in multiple ways.
In Tableau, this was very easy. The parameter feature let me easily swap other measures in and out of a formula. In a table chart, I could literally choose ten different ways to group my data and place the columns side by side.
Can Power BI do this? Am I missing something? Because I've been trying for days now to get this done - I've read a 300 page book, and I still just don't know how to do this.
Yes, power BI can filter. It can do one hiearchy. But that's not enough. Can I create a line chart where I can choose what date level goes on the X axis (months vs quarters vs other), I can also choose what level to show the lines at (one line for total, 3 lines for departments, or 10 lines for the categories below that), and also simultaneously choose what the lines are on the chart (sales vs profit)?
I'm pulling my hair out trying to get this done. I can do the last one (sales vs profit), and even a hierarchy on the X axis, but not another on the Y axis (to choose what lines are shown).
Can power BI let me dynically swap this in and out? Can it really do what we need?
