Forum Discussion
Data did not change when dynamic field changes in Line and Clustered Column chart.
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)
10 Replies
Hi Anonymous ,
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.
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 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
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.