Top Tutorials from www.PowerBI.Tips for 2016

www.PowerBI.Tips is a website that produces tutorials for Power BI Desktop and Power BI online service. This dashboard is the collection of all the hits by tutorial for all of 2016. All data has be...

Business

how to

Technology

Mike_Carlo
9 years ago
Great question and I'm glad you are checking out my top tutorials. Here is a suggestion for incorporating multiple entries for each state.

Try creating a measure such as Total = sum( 'Data from Google'[Sessions]) This will for each state total all the numbers of sessions by each state.

for this paricular visual I was able to use the Shape Map. Here is how the visual looks and the measure I created:

Total = SUM('All Web Site Data'[Entrances])

That should get you closer to an acceptable solution.

Mike

Keha

Frequent Visitor

9 years ago

Hey Mike,

i have checked out your link and I have found many great insights and ressources. However, the interactive map in this current Bi I find fascinating and would love to implement it into my reports. I am sure that the map is similar to the one you have pointed out in one of your tutorials. However, I do not have sum values for each state, but more a table with different values for the same state as i am trying to visualize my GA Session by state. Any suggestions on how the next step might look like?

Thanks for your help,

Kevin

Mike_Carlo

Most Valuable Professional

9 years ago

Great question and I'm glad you are checking out my top tutorials. Here is a suggestion for incorporating multiple entries for each state.

Try creating a measure such as Total = sum( 'Data from Google'[Sessions]) This will for each state total all the numbers of sessions by each state.

for this paricular visual I was able to use the Shape Map. Here is how the visual looks and the measure I created:

Total = SUM('All Web Site Data'[Entrances])

That should get you closer to an acceptable solution.

Mike

Keha
Frequent Visitor
9 years ago
Hey Mike_Carlo,

thanks so much for your quick reply and your suggestions! Your Scrrenshots revealed the visual (Shape Map) that I had yet to discover within the BI. You need to select it within the Options of Power BI.

Following your way, I know am able to create a individual map for what I was looking for!

Thank you so much for your help. Getting there. I think Power Bi is a great tool and if you get into it it is also quite easy to learn. Expecially from you guys. Thumbs Up!

Kevin