Forum Discussion
Dynamic Line and Column chart from bipatterns.com
Learn how to create a Line and Column chart that is dynamically created via slicers. Go to bipatterns.com for a guide.
If you're in PowerPivot: you can create the table in excel and import it into Powerpivot.
PowerBI: Select "Enter Data" and type or paste your measure names into the table.
SSAS (any version before 2016): You can paste data from the clipboard, similar to PowerPivot.
The remaining option would be to add a simple SQL table statement to the ETL that loads the cube.
If you have more details on what you're using/where your data is coming from, or any other questions let me know.
I added it to the bottom of the post on my blog. If you have any issues with opening it, please let me know. I hope this helps, but let me know if you need anything else. I'm working on building out my blog with a lot of techniques I've been using, and this has been just one of them.
Thanks
Or were you refferring to something like this:
Please mark it as a solution or give a kudo if it works for you, otherwise let me know if you run into an issue and I'll do my best to assist. Go To bipatterns.com for more techniques and user guides.
Thanks,
8 Replies
Hi Anonymous
Thanks for sharing the dynamic slicer based visualisation.
I have gone through the Bipatterns.com.
Could you please help me with the syntax/Dax to create new disconnected table in this case
setp2:
Create the disconnected tables, highlighted in red above. These tables will consist of two columns, Position and Variable (Column or Line Variable for example). The position column serves as a row index, while the Variable column will contain the names of the measures you want to use dynamically.
If you're in PowerPivot: you can create the table in excel and import it into Powerpivot.
PowerBI: Select "Enter Data" and type or paste your measure names into the table.
SSAS (any version before 2016): You can paste data from the clipboard, similar to PowerPivot.
The remaining option would be to add a simple SQL table statement to the ETL that loads the cube.
If you have more details on what you're using/where your data is coming from, or any other questions let me know.
Any chance can we get the PowerBI file and PowerPivot model.
