In PowerBI, I've created a couple tables (DateKey and Country-Area) that I use manage relationships to be able to filter on my reports.
However when I use Anayze in Excel, those relationships seem to be lost for filtering.
I'm trying to filter the Analyze in Excel by Area. It works in PowerBI, but in Excel, it doesn't filter anything. I get the entire dump of database.
Also, I'm adding Year in the report to be able to select data by year. Again, able to do this in PowerBI, but in Excel, the Year column seems to be losing it's mapping and I'm getting 5 duplicate rows except for Year column:
I read other threads, and the Year one seems related to Date column changing format in Excel to General instead of Date, so probably the relationship mapping isn't applying correctly outside of PowerBI.
Not sure why I'm not able to filter by Area which is mapped to Countries though. I've tried setting relationship both Single and Both.
Would like to filter the Analyze in Excel Pivot data by Area's that are defined in the table.
Any ideas on how to get this to work (besides creating a column in the main data set)?
-
DNMAF
on:
Adding a measure or column as a tooltip to an Azur...
-
parry2k
on:
A Typo about Refence Line in the Format (Korean)
- ricardo_ona on: UDFs annotations Issue with Invoke-ProcessASDataba...
- DeeBaxo on: Export to PowerBI directly from Sharepoint List
-
mattlee
on:
Automatically expand table columns to fill availab...
- Ghoom on: Azure Maps Controls -> Selection Greyed out
-
awright19
on:
Open old report, PowerBi hangs
-
mattlee
on:
Error：Visuals display blank when export report to ...
-
mattlee
on:
New Button Slicer: Issue with the Grid type of Arr...
-
mattlee
on:
List Slicer Button Dimensions Ignored in Service