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

The ultimate Microsoft Fabric, Power BI, Azure AI & SQL learning event! Join us in Las Vegas from March 26-28, 2024. Use code MSCUST for a $100 discount. Register Now

Reply
ruthhacche
Helper III
Helper III

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 @ruthhacche ,

 

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

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 @ruthhacche ,

 

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

ruthhacche
Helper III
Helper III

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

Helpful resources

Announcements
Fabric Community Conference

Microsoft Fabric Community Conference

Join us at our first-ever Microsoft Fabric Community Conference, March 26-28, 2024 in Las Vegas with 100+ sessions by community experts and Microsoft engineering.

February 2024 Update Carousel

Power BI Monthly Update - February 2024

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

Fabric Career Hub

Microsoft Fabric Career Hub

Explore career paths and learn resources in Fabric.

Fabric Partner Community

Microsoft Fabric Partner Community

Engage with the Fabric engineering team, hear of product updates, business opportunities, and resources in the Fabric Partner Community.

Top Solution Authors
Top Kudoed Authors