Forum Discussion
Dynamic Line and Column chart from bipatterns.com
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,
Hi Anonymous
I have been using the given BI pattern and it was very useful.
Any chance that we can apply this to Line and clustered column chart. What I mean is to choose multiple measures on Line displaying multiple line on the chart each line for each measure and similar case with Multiple measures on column.
Please advise. Thank you!
Are you looking for 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,