Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Find everything you need to get certified on Fabric—skills challenges, live sessions, exam prep, role guidance, and more. Get started

Reply
Anonymous
Not applicable

Connected refreshable excel pivot within PBI app (new)

We have published a refreshable excel pivot into an app (see Wyn Hopkins' excelent video here -  Power BI connected Excel Pivot Table embedded in App - YouTube) and note: 

 

1   If we add a date filter to a row (using a field defined as a date field within the dataset) it will not filter as a date (we only get text or value options).  The Date is coming through as a text field.  This happens if we create the pivot using Analyse for Excel or Get Data and regardless of what formatting we use for the date (eg dd/mm/yy or dd mmm yyyy) - is this a bug or do we have something wrong?

ruthhacche_0-1627109873244.png

 

2  The fields available for the pivot do not show the descriptions (this is MUCH needed when the pivot is published into the app; how can we expect users with little knowledge of the underlying model to pick relevant fields?):

 

So this description in the dataset...

ruthhacche_1-1627110114961.png

 

..does not appear in the published pivot (nor in the actual pivot creating analyse or get data)

ruthhacche_2-1627110194889.png

 

3   It is realy useful for measures to appear at the top of the list of tables as they do in the dataset but in the published pivot they are just alphabetical - is that intentional?

Has anyone else noted anything when using this functionality - it is undoubtably a massive step forward to be able to publish connected refreshable pivots within the app.   Now we just need drill through from the rest of the app to the slicers on the pivot (so if I am on a report page filtered for one subset of accounts and one fiscal year, and I have account subset and fiscal year slicers on my pivot connected to that dataset, I can drill through to the pivot pre-filtered).

 

4 REPLIES 4
v-deddai1-msft
Community Support
Community Support

Hi @Anonymous ,

 

For 1:

 

Could you please try to change the data type from text to date?

 

For 2

 

It seems be by design. You can create an idea for it  in

https://ideas.powerbi.com/forums/265200-power-bi-ideas to improve the power bi.

 

For 3,

 

As a workaround, you can create an measure table, to put all measures in the data model to one table.

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Anonymous
Not applicable

1 As mentioned they are already formatted as dates.  I am pretty sure this must be a bug.  The only way of going further on this is if someone tries to recreate it.

3 All the measures are already in tables - that is my point.  But measure tables do not come to the top, they just get lost in an alphabetical sort.

Hi @Anonymous ,

 

The date column show date type in power bi?

 

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

 

Best Regards,

Dedmon Dai

Anonymous
Not applicable

To add to the above - because dates are nto formatting as dates, I cannot add a timeline slicer to the pivots.

Helpful resources

Announcements
July 2024 Power BI Update

Power BI Monthly Update - July 2024

Check out the July 2024 Power BI update to learn about new features.