All Questions
Tagged with powerpivot powerview
34 questions
0
votes
1
answer
95
views
Column order in PowerView
I have following sample data in PowerPivot:
id name type color
1 aaa x blue
2 bbb y red
3 ccc x blue
4 ddd y orange
5 eee z ...
- 97
0
votes
1
answer
157
views
Excel power view sheet comes out blank when printing
When I try to print a power view sheet it comes out blank (no ink on the paper), even though the print preview shows the sheet nicely.
See image below (secret stuff is blurred out):
According to ...
- 103
0
votes
0
answers
46
views
Power View - Tables with columns of the similar data
Apologies in advance if my question is obvious but I'm new to this and having spent days searching and experimenting I cannot achieve the result I'm after.
I have a big table of data that I want to ...
- 1
0
votes
1
answer
51
views
How to implement Dynamic Security in PowerView
I have created a PowerView using a BISM connection in Enterprise Portal of AX. That PowerView report will be used by 100+ users. I want every user to his/her data in the PowerView instead of viewing ...
- 21
0
votes
1
answer
165
views
What is the equivalent of Excel's Subtotal in Power Pivot?
Is there a way to count the total number of rows returned in a filtered table in Power Pivot? I tried populating a column with 1 or 0 and used SUM. But it returned the number of rows in the original ...
- 489
1
vote
2
answers
1k
views
Filter dynamic in power bi
Is it possible to do a dynamic filter in power Bi?
I want to show TOP 20 or TOP 10 or TOP 5 in columns chart. Now I have a filter with less 20 , but I need to mark in slice and show other data.
...
- 105
4
votes
1
answer
330
views
DAX Dynamic Total with Power View
I am attempting to graph, via Power View, the sum of all account balances at various points in time, so that I can see how the total is changing.
I do not have transaction history (add / subtract), ...
- 41
1
vote
0
answers
82
views
Conditional Drill Down Powerview
Not sure if this is doable but I just wonder say if my data set got this structure
Department, Team, Service, Area
and I got a measure lets call it #count that count all rows in this table.
When ...
- 403
1
vote
1
answer
172
views
How to link table row content to source in Power View
I am currently able to use Power View to view, filter, and highlight my data. However I haven't figured out a way to link my table rows to the data source (i.e. tables in other tabs of the Excel ...
- 35
1
vote
2
answers
542
views
How to create nested tiles in Power View
I am currently able to use the tile feature in Power View to view data much more quickly. However I haven't figured out a way to have nested tiles to further drill down into the relevant data.
For ...
- 35
0
votes
1
answer
2k
views
PowerBI hierarchy creation without the cloud
Right now we can create hierarchies in PowerPivot but I'm pretty sure I can't do it in PowerBI. I could create a Data Model in PowerPivot and use that for PowerBI I think. Is there any other work ...
- 3,470
0
votes
1
answer
375
views
How to create Power View report tiled by multiple KPIs?
I am trying to create a Power View report tiled by KPIs, is this possible?
An example of my raw data:
Company ID Employee ID Measure numerator denominator
1 01 1 ...
0
votes
0
answers
1k
views
Power View Error - an item with the same key has already been added
I need a solution in resolving an error which pops out in Microsoft Power View. After creating the model using Excel Power Pivot without any linkage errors, I tried to create Power views from the ...
1
vote
1
answer
4k
views
Display Image in Power View and Power BI
I need to create a report in power view where I need to display images in tile. I have found one solution to do so, to store the images as a binary data in data model table using the following link
...
- 847
-1
votes
1
answer
219
views
How to visualise a SQL Server view using powerView in Excel?
I'm new to data visualisation and powerview etc. but I have the following view in SQL Server:
--This view displays any delivery that was late and by how many days
CREATE VIEW [Display Late ...
0
votes
2
answers
3k
views
Top 5 and Bottom 5 records in Power Pivot
I am trying to show top 5 records and bottom 5 records in two separate tables in Power View.
I have created a calculated measure to show the records.
But it doesnt giving me the required result.
...
- 847
1
vote
2
answers
200
views
many to many powerpivot relationship
I have 2 data sets which i would like to create relationships for (there is a third i would like to join but the first 2 are priority). They all have a common link that is design_ID.
I did have a ...
- 55
2
votes
1
answer
2k
views
What is the DAX for sum of percentages
I have a table where I have to create percentages by looping on the same table. Here is the sample table
My first hurdle is to create the %Weightage, which for a given day, is the percentage of ...
- 31
0
votes
1
answer
158
views
Powerview drop filter context on a column
I'm currently working on a power view project where I need to display the numbers of the gross market and compare these to the numbers of a certain customer.
In this particular example, the market ...
- 121
1
vote
0
answers
358
views
How to have dynamic interval in DAX/Powerpivot?
Dynamic Band in RDBMS
Our challenge is to reproduce the below example (RDBMS) but leveraging Microsoft SSAS Tabular Model.
We have value in a column and we need to group them, so literally we have ...
- 133
1
vote
1
answer
1k
views
Is it possible to order the filters on the filter pane of Power View?
I have noticed that the filters added to the filter pane in Power View Reports are automatically ordered by field name, is there a way to rearrange them without changing the field names?
In my case I ...
- 11
1
vote
1
answer
477
views
how can i use or implement Power BI feature in SharePoint 2013?
I have been using Power BI features in Excel 2013 and was wondering what do I need to do to get them working in SharePoint 2013.
- 507
0
votes
1
answer
2k
views
DAX - selecting rows with partial match
I have a powerpivot table that contains 2 columns:
Column 1 contains strings.
Column 2 contains comma delimited strings.
I would like to be able to display all the rows from column 1 when rows from ...
- 61
1
vote
1
answer
1k
views
Map Chart works in Power Map but does not work in the Power View Map
I am building a simple map report using Excel 2013 with Power Map and Power View. I struggle to understand why the same data are displayed correctly in Power Map; however, fails to display anything in ...
- 2,016
3
votes
2
answers
29k
views
PowerView in Excel 2010
Can anybody tell me any difference in PowerView in Excel 2010 and PowerView in Excel 2013? I have already tried looking for differences but couldn't find the information i need.
0
votes
1
answer
2k
views
PowerPivot - How to calculate trend by comparing two periods?
I'would like to create a KPI to compare results from two periods.
My data source looks like the following example :
User | NB sales | Date
Bob | 10 | 01/01/2014
Tim | 20 | 01/01/2014
...
- 741
0
votes
1
answer
529
views
PowerPivot - How to grab data from Yahoo webservices
I would like to import weather forecasts in PowerPivot for a specified country by using Yahoo API.
So first of all I got the data stream URL including all requiered parameters to get forecasts (it ...
- 741
0
votes
2
answers
885
views
Power-Pivot:500 Internal Server Error
I am importing the ssrs report from .automsvc extension and I am facing the below issue as .Can any one help me how can I solve this issue
Tablix1: The remote server returned an error: (500) Internal ...
- 115
0
votes
1
answer
6k
views
PowerPivot - How to create a INNER JOIN between multiple sources
I'm working on a PowerPivot project and I need to create a join between a SQL Server query retrieving a list of products (including prices) and an Excel data sheet containing products and other prices....
- 741
0
votes
1
answer
38
views
Filter mutliple tables with one Tile
i am currently trying to Filter all of my Tables in a sheet using one Tile for the Employees.
I have tried selecting everything, but then The Tile Button gets greyed out.
is there anyway of filterin ...
- 301
1
vote
2
answers
3k
views
convert excel column from json to record using powerview
I am storing arbitrary objects (the "data" column) in a RMDB database using a format similar to the following:
<id> <object id> <object category> <creation date> <created ...
- 15.2k
1
vote
1
answer
6k
views
Sharepoint 2013 Excel Services not rendering Power View reports inside a workbook
We want to be able to publish Excel 2013 workbooks containing Power View reports into SharePoint 2013 and see them via Excel Services application.
Currently instead of the actual report we see the ...
- 113
1
vote
1
answer
2k
views
Sort chart legend in PowerView
I'm playing about with PowerView at the moment and have run into a slight issue. I've got a line chart (below) but would really like to sort the legend (Keyword) depending on the latest value of the ...
- 5,485
1
vote
1
answer
180
views
Power view layout issue
Anyone developing on power view?
I have a slicer on the year but I would like to display it in X columns instead of X rows. Its kind aeasy to do it on power pivot but I cant figure it out how to do it ...
- 36k