Hi Mynda, Thanks. The syntax for [LostDaysLimit] wasn't correct so I ended up typing in 1096 days into the measure. I then tried the formula you...
Hi Catalin, That is the exact problem. Drilling down in Column D Customers with Both Products returns Column C Customers, when what I want it to do...
Hi, Is anyone able to assist with my question on the slicer not working when drilling down to the customer list? I have emailed the model over. Tha...
Hi Catalin, Thanks for your reply. My question is, when I import an Excel file into Power BI, it only shows the sheets which I have closed and load...
Hi Catalin, I have emailed the model with dummy data to [email protected]. Thank you.
Correction - my pivot table fields are from the DimBusinessArea, while the slicer fields are from the FilterDimBusinessArea. Thank you.
Hi Mynda, It must be a setting on my file. A colleague of mine solved it by clicking on Data, Queries & Connections, Connections at the top of ...
Hi Mynda, I am getting this same issue with another file. When I drill down a cell from my Power Pivot Table, it returns only 1,000 rows instead of...
Hi Mynda, Thank you for the reminder. With Data tab > Existing Connections, I was able to import the ODC file but the checkbox for 'Add to Data ...