Fabric is Generally Available. Browse Fabric Presentations. Work
towards your Fabric certification with the Cloud Skills Challenge.
My client would like to compare the data on different periods like in the screenshot below but it does not work for me (I should see data on period 4).
Here are my measures :
And my parameter that I put on Y axe :
And here is the data model behind (only the dates tables layout) :
Is this scenario at least possible in Power BI ? If yes, where I am getting wrong ?
Hi @DM_EU ,
Looking at the model since the tables have inactive relationships there is no need for you to remove the filters from the other tables, since the calculation will go trough the active relationship.
But without any data is difficult to pinpoint the issue.
Can you please share a mockup data or sample of your PBIX file. You can use a onedrive, google drive, we transfer or similar link to upload your files.If the information is sensitive please share it trough private message.
If you can also give an expected result would be great.
Proud to be a Super User!
Check out the November 2023 Power BI update to learn about new features.
130+ sessions, 130+ speakers, Product managers, MVPs, and experts. All about Power BI and Fabric. Attend online or watch the recordings.