The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredEnhance your career with this limited time 50% discount on Fabric and Power BI exams. Ends August 31st. Request your voucher.
Lets say we have a data set which has "year" among other dimensions (not the datetime - year as integer), and visual built upon this dataset. We also have a calendarauto() based slicer which allows us to select year and filter displayed data. Visual's dataset is NOT linked to calendarauto() table.
Is there any way to create a link between the slicer and this visual, so selecting year on the slicer would filter the data?
Hi @Anonymous ,
You can create a YEAR column in Calendar Date table. Then use this column to establish a relationship between you data-set and Date table.
This will make slicers work the way you are looking for.
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
Relationships are out of question because of the dreaded "circular relationship" error. We just cannot create them when needed.
Hi @Anonymous ,
Is there an existing relationship betwwen your Date table and data-table? Or are these individually connected to any other table?
Can you try pasting a screenshot of the data model with relationships in Power BI here?
If this helps and resolves the issue, appreciate a Kudos and mark it as a Solution! 🙂
Thanks,
Pragati
There is no relationship (within the model).
Hi @Anonymous ,
Can you paste your sample data here, along with the datatypes the columns have in both tables?
Thanks,
Pragati
I cannot post the sample data because, if I only recreate 2 tables the answer would be "create a relationship". But as I've already mentioned above, creating relationship is out of question because this would create circular relationships.
The question is rather simple. There is a CALENDARAUTO() - based slicer that lets you select years. There is also a table that has a "year" column (integer) and other data, and visual built using this table. The goal is: slicer should filter the visual.
I cannot even reproduce this configuration in actual file. In your example, CALENDARAUTO-based table has no year/quarter/month fields - somehow, because in real file it is impossible to remove fields or edit CALENDARAUTO() hierarchy in any way.
How did you delete hierarchy from calendarauto?
Hi,
It is because i created relationship between them which will break the calendar hierarchy.
Please check my attached file again.
Best Regards,
Giotto
User | Count |
---|---|
78 | |
74 | |
43 | |
32 | |
28 |
User | Count |
---|---|
104 | |
93 | |
52 | |
50 | |
46 |