#USERELATIONSHIP -Revealing the power of inactive relationships in DAX

Sami Anderson
Nov 1 · 1 min read

In a recent Power BI report, we came across a situation where we needed to visualize factual data (monthly goal KPI) in two forms. One being a simple KPI form and the other in the form of a graph filtered by the dimension date range in the axis.

Here comes the tricky part, there were two date fields available in the dimension table. One having the first date of a month named as startdate and the other having the last date of a month named as enddate.

Initially the startdate field of the fact table and the dimension date field were related.

The monthly goal KPI visual was working fine. But when the KPI was filtered by the dimension date field and placed on an axis, it produced a graph where only the first date of the month is included in the graph and not the other dates selected in the date filter.

The actual graph requirement is to have all the dates included in the graph for which it is filtered.

Read More…

Sami Anderson

Written by

Marketing Coordinator at Softcrylic LLC. posting stories on behalf of my company and colleagues. www.softcrylic.com

Welcome to a place where words matter. On Medium, smart voices and original ideas take center stage - with no ads in sight. Watch
Follow all the topics you care about, and we’ll deliver the best stories for you to your homepage and inbox. Explore
Get unlimited access to the best stories on Medium — and support writers while you’re at it. Just $5/month. Upgrade