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