Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
10 years ago
Solved

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.      
Dashboard
  • Anonymous's avatar
    Anonymous
    10 years ago

    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.

  • Anonymous's avatar
    Anonymous
    10 years ago

    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

  • Anonymous's avatar
    Anonymous
    10 years ago

    anithat

     

    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,

    Ryan Durkin

Anonymous's avatar
Anonymous
Not applicable
10 years ago

anithat

 

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,

Ryan Durkin

anithat's avatar
anithat
Resolver II
10 years ago

Hi Anonymous

 

Yes, it is similar to this. Multiple bars and multiple lines chart.

 

It looks like you have taken two variables into one single variable and mapped it to the line.

 

Similar logic should work for columns as well which I will try.

 

Could you please share the pbix for the latest chart.

 

Also, What I am trying to achieve is little different from this.

 

I have two Line and column measures as below

 

Column:

Sales TY

Sales LY

 

Line:

Units TY

Units LY

 

Instead of chiclet slicer, I have taken regular slicer on pbi. Enabled the multiselect option. This allows me to select both the values from column and line.

 

Selecting sales TY & Sales LY should display two bars on chart with diff colors.

Selecting Units TY & Units LY should display two lines on Chart with diff colors.

 

In your case, to get this you are trying to map Units TY & Units LY to one variable and using which restricts the selection.

 

I want this to be dynamic, user should be able to chose either one measure at a time on column and line or two measures each at a time

Thank you!