PowerBI: Dynamically change X & Y axis using parameter & switch statement when selected in filter

[@Sirigineedi_Navann]

Nice one Bhai Keep posting the video's thanku so much

[@Howtosolveprobem]

Thanks for the feedback ✌🏻

[@monubhaiya9022]

thanks for teching plese bring more videos

[@Howtosolveprobem]

Thanks for the feedback ✌🏻

[@chaitanyalanka7043]

Hi your videos are very useful thank you for the explanation, I have one doubt that is I have 3 measures and showing in clustered bar chart along with the month column in x axis so I have to create one target value for each measure showing in the bar chart and the three values are constant and that target value should be shown in the same chart along with line chart is this possible

[@Howtosolveprobem]

Hi Thanks for you feedback, n yes its is possible to create three different constants value, yes there some limitations thay depends on your measure Here are the steps once you create chart with three measures vs month chart the click on search icon next to format your visual pane then click on constant line the by creating new constant line, Line option, check value fx function there you can color/format line

[@eduardorommeocastulolopez4814]

Hi, thanks for your video. I wonder if there is another way to simulate the field parameters? Just to let you know, Im working with Report Server PBI and by my admin that feature is disable, I just want to switch between facts eg: "Product" and "Country" from one single table named Sales

[@Howtosolveprobem]

@@eduardorommeocastulolopez4814 Hi there is one work around is you can create how hide button instead of slicer if you have only two fields where you need to toggle it can be achieved by creating two charts second option that i tried using summarise funtion where i am able to achive the chart using slicer change but here the challenge is to make relationship btw parent table and summarize table if i am able to establish relationship btw parent n sumary table then it is doable