Data did not change when dynamic field changes in Line and Clustered Column chart.

[vermillion]

https://drive.google.com/drive/folders/19XWky9rj5hgF5MV-Gqfr29BN8-74Y4vn?usp=drive_link 

Hello All,

Please help me. I use "line and clustered column chart" for my project.  I created dynamic fields for "All Site Dollar," "ZTA," and "Calendar" and moved them to the visual of the graph.  When I clicked on "mABC Dollar," the clustered and line chart data changed because I configured the line chart with the value of "MinABC ML".  However, When I clicked on "mDEF Dollar," the data on clustered changed, but the value of the line chart did not change. I saw the value of the line chart was still "MinABC ML".  I don't know how to change the line chart's value from "MinABC ML" to "MinDEF ML".  It happened the same when I clicked on "mHJK Dollar".  Please help me on this matter.  Thank you so much for your help.

PS.  I shared a link to my ZTA.pbix file (above)

[vermillion]

[vermillion]

When I clicked on mABC Dollar (All Site Dollar Dynamic field), the clustered chart changed but the line Y-axis is MinABC ML.

When I clicked on mDEF Dollar (at All Site Dollar), the clustered chart changed to the value of mDEF Dollar, but the line still has a value of MinABC ML.  It is supposed to change the value to MinDEF ML. 

[v-yangliu-msft]

Hi  @vermillion ,

Sorry, I can't open your PBIX, I can't reproduce your scenario for the time being.

According to what you mean, the value of the line graph in visual has not changed, you can try to check whether the value of X-axis has data when mDEF Dollar is displayed, if not, it will not be displayed.

Can you share sample data and sample output in table format if it's convenient for you?

Is the version of Power BI Desktop up to date, if not, please update and reopen it in the link below.

Download Microsoft Power BI Desktop from Official Microsoft Download Center

Best Regards,

Liu Yang

If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

[vermillion]

Hi Liu,

"you can try to check whether the value of X-axis has data when mDEF Dollar is displayed, if not, it will not be displayed." the value if X-axis is Fiscal Year value, it changed.  Only the value of line chart on Line y-axis is not changed if I clicked on different "site dollar"

[vermillion]

I used the latest version of Power BI Desktop

[vermillion]

Hi Liu,

Thank you so much for your golden time to work on my post.  

Calendar table.

Year	Fiscal Year
2025	FY24/25
2026	FY25/26
2027	FY26/27
2028	FY27/28

Site Budget for ABC site.

Pillar	Functions	Capabilities	2025	2026	2027	2028
Identity	Authentication	MFA	$25,060	$78,941	$215,614	$2,452,122
Device	Resource Access	Zero Trust Principle	$2,452	$7,825	$4,755	$752
Network	Traffic Encryption	Transport Encryption	$175	$24,175	$1,542	$47,552
Application	App Security Testing	Automation	$0	$7,441	$0	$7,541
Data	Data Access	Data privacy	$44	$51,174	$0	$754,527

[vermillion]

Site Budget for DEF site:

Pillar	Functions	Capabilities	2025	2026	2027	2028
Identity	Authentication	MFA	$754	$2,157	$0	$4,274
Device	Resource Access	Zero Trust Principle	$0	$751	$0	$965,244
Network	Traffic Encryption	Transport Encryption	$7,511	$555	$7,514	$75,312
Application	App Security Testing	Automation	$0	$5,231	$0	$7,514
Data	Data Access	Data privacy	$1,242	$0	$85,741	$96,854

[vermillion]

Site Maturity Level for ABC sites:

Pillar	Functions	Capabilities	2025	2026	2027	2028
Identity	Authentication	MFA	1	1	3	4
Device	Resource Access	Zero Trust Principle	2	2	3	4
Network	Traffic Encryption	Transport Encryption	1	1	3	4
Application	App Security Testing	Automation	1	2	2	4
Data	Data Access	Data privacy	1	1	1	3

[vermillion]

Site Maturity Level for DEF site

Pillar	Functions	Capabilities	2025	2026	2027	2028
Identity	Authentication	MFA	1	1	2	2
Device	Resource Access	Zero Trust Principle	2	3	4	4
Network	Traffic Encryption	Transport Encryption	3	3	4	4
Application	App Security Testing	Automation	1	2	2	3
Data	Data Access	Data privacy	1	1	2	4

[vermillion]

ZTA table

Pillar	Functions	Capabilities
Identity	Authentication	MFA
Device	Resource Access	Zero Trust Principle
Network	Traffic Encryption	Transport Encryption
Application	App Security Testing	Automation
Data	Data Access	Data privacy