#USERELATIONSHIP -Revealing the power of inactive relationships in DAX
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.
