Skip to main content
cancel
Showing results for 
Search instead for 
Did you mean: 

Don't miss out! 2025 Microsoft Fabric Community Conference, March 31 - April 2, Las Vegas, Nevada. Use code MSCUST for a $150 discount. Prices go up February 11th. Register now.

Reply
WaleedBinAli
Frequent Visitor

Need help with Graphical Visualization

Hi there,
Thanks in advance.
I want to create a graph in which on x axis there should 2 values one which will always exist when nothing will be clicked in table such as PROFIT AFTER TAX and other value should be displayed on that graph when some field is clicked on table.

Suppose, country name should be displayed on x label and on y axis actual, budget and projection these values are given. Value of Profit after tax should always be visible when nothing is clicked in table when some field or value is clicked that should be displayed instead of profit after tax and when unchoose the field or value from the table then it display profit after tax in that graph. I am using Clustered Column Chart.
Q1.PNGQ2.PNG

3 REPLIES 3
WaleedBinAli
Frequent Visitor

Any solutions??

amitchandak
Super User
Super User

@WaleedBinAli , I would advise exploring field parameters in Power BI. Bit different but can solve the purpose 

 

https://amitchandak.medium.com/power-bi-field-parameters-a-quick-way-for-dynamic-visuals-fc4095ae9af...

 

 

Join us as experts from around the world come together to shape the future of data and AI!
At the Microsoft Analytics Community Conference, global leaders and influential voices are stepping up to share their knowledge and help you master the latest in Microsoft Fabric, Copilot, and Purview.
️ November 12th-14th, 2024
 Online Event
Register Here

Thank you @amitchandak 
Just let me know can we specifically assign a slicer only to graph. Where it change only the values in graph not on whole page.
And the field parameters are good will use when i will update my Bi. 

Helpful resources

Announcements
Las Vegas 2025

Join us at the Microsoft Fabric Community Conference

March 31 - April 2, 2025, in Las Vegas, Nevada. Use code MSCUST for a $150 discount!

Jan25PBI_Carousel

Power BI Monthly Update - January 2025

Check out the January 2025 Power BI update to learn about new features in Reporting, Modeling, and Data Connectivity.

December 2024

A Year in Review - December 2024

Find out what content was popular in the Fabric community during 2024.