powerview

Beste, Mijn voormalige manager, CEO van Ypto, de IT leverancier van de NMBS, zoekt dringend een excel expert met kennis van PowerPivot en PowerView. Het betreft hier een korte opdracht van ongeveer 1 week. Mogelijks kunnen nieuwe opdrachten volgen. Als je in België woont en interesse zou...

I have an Excel file with a tab of PowerView map. I upload this file to OneDrive and view the file on Excel online (office.com) The pivot Table etc are displaying, but the PowerView Map is not displaying. Please help. How to enable displaying on Office.com Thanks

Is there any way to get the PowerPivot and PowerView Add-ins in the 365 version of Excel 2016?

Hi all, Is there any way to view the actual data that is powering a PowerView output? For instance let's say I apply a filter and I'm seeing 5 records. I'd like to have an easy way to view the actual data. Sort of like when you create a pivottable and pivotchart together. Thanks!

Hi all, So I'm pretty new to PowerView. I've created a column in the Data Model to format dates into "mmm-yy" format. Created a measure to count the number of times each month occurs using a calculated count. Problem is it sorts in alphanumeric order and note in date order. I created another...

I've never found an Excel problem that I couldn't solve by googling... until today. I've googled this problem for 2 hours, and I DID search this forum before posting. I'm using power pivot with power query, and I have a workbook with more than 30 queries, more than 5 million lines of data. In...

I am a still operating Excel 2010, and I keep trying to open Powerview on the ribbon, but I can't get it to work. I followed the steps to adding it to the ribbon, but it simply won't appear on there. Any tips as to how to get it to work?

I've created a PowerView based on a merged Power Query. Basically I've taking Actual hrs, Estimate At Complete (EAC) and Budget hours from several different sources and linked them by Work Breakdown structure (WBS) in a merged Power Query. I then used PowerView to display the data in a table...

Excel 2013 Pro, 64-bit on windows 7 running on a quad core i5 with 8Gb ram. All files are local. The file is averaging about 150 Mb and links to six others which in total average about 100Mb. It has five Powerview worksheets which each reference the one Table range. This Table is 38k rows by...

Hi, I'm trying to figure out if there is a way to separate the Power View from the actual workbook. I want to email out the Power View report only, without having to email them the workbook containing the raw data. Any help would be greatly appreciated. Thanks!

Hi All, I've got a big table of data and within it I've used 'post code' to plot points on a map using PowerView. These locations were visited in order and it would be very useful to see in what order they were visited - preferably by connecting them with a line (either as the crow flies...

In one of our tables we have a measure for Zip Code in the current format "00000-0000". I wanted to create a calculated measure grabbing only the left 5 characters so we can plot them easier on a PowerView Map. I tried creating a calculated field using "=LEFT(Ship-to Customer'[Zip],5)" and i...

hi there everyone, i am struggling with the following task in PowerPivot/Powerview for excel2013 (see tables below) : Table A: "Jobs Data" has information on "Production Jobs" - each row has a unique job ID number. Table B: "Direct Labor Data" has records with information about "direct labor"...

Please excuse if this is a repeat, but: I am trying to create a matrix style table in powerview that shows the day of the week in the rows (I have a day of the week field in my data model table) and the hour of the day in the columns (I have a time in field in my data model table). With normal...

Hello guys, I have a table that contains how much a client paid for an invoyce ([Valor NF]) and which department received that money. However, my company divides a department in 3 hieararchical levels, which are then represented in the workbook by 3 fields named Dept. Lvl. 1, 2 & 3. Here is my...

I would like to create a map of the U.S in Powerview with 2 sets of bubbles showing number of hospitals in each state (as blue bubbles) and the number of nursing homes in each state ( as red bubbles). My data table is simple as follows: state #hospitals #nursing homes Alaska...

Hi, I've used PowerPivot to get some data out of an Oracle warehouse, the data includes a total number, and then a target for the week and a cumulative target for the week so far. I've then created several if statements in new columns to determine whether the total has met either the cumulative...

Goal: To create a visualization that ranks my cities based on the filters I click on the other graphs in my Dashboard; displayed as a percentage. Background: I have 50 cities. Each city has supplies (ex: notebooks, pencils, pens). However, some of the supplies are broken. I have a pie chart...

Good morning all--I am looking to incorporate PowerView into my workbook. The issue I have is I am unable to get my origin points to show up. I have Columbus, IN and Terre Haute, IN that I want to show on their Map Visualization. I have been able to get just the state abbreviation to work IN...

Hi, Please find an example of the table below which I am trying to put in a map in Power view. Power view opens but do not recognize / locate the addresses in the Czech Republic. Funnily enough, using the same table, Power Map is able to locate the address automatically. Power view works as I...