The ultimate Fabric, Power BI, SQL, and AI community-led learning event. Save €200 with code FABCOMM.
Get registeredCompete to become Power BI Data Viz World Champion! First round ends August 18th. Get started.
Hi , I have created a KPI visual and I have set the indicator Date and Target as the Total Target Revenue. I have some filters but the Target is not changing with Filters. I am bit new to Power BI , the indicator value is changing but not the target but it has to chage as well with the filters.
Can someone please help me.
Thanks
Solved! Go to Solution.
Thanks. I found the issue.
When I created the relationship between the tables the Cross filter direction was single because of that it was not filtering for the other side of the table. once I made it to both below its working fine.
it did not work for me
You might have to move your Date field to Trend Axis. See here for more details on KPI visual:
https://docs.microsoft.com/en-us/power-bi/visuals/power-bi-visualization-kpi
Thanks. I found the issue.
When I created the relationship between the tables the Cross filter direction was single because of that it was not filtering for the other side of the table. once I made it to both below its working fine.
User | Count |
---|---|
26 | |
10 | |
8 | |
6 | |
6 |
User | Count |
---|---|
31 | |
11 | |
10 | |
10 | |
9 |