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

แชร์
ฝัง
  • เผยแพร่เมื่อ 15 ธ.ค. 2024

ความคิดเห็น • 8

  • @monubhaiya9022
    @monubhaiya9022 8 หลายเดือนก่อน +1

    thanks for teching plese bring more videos

    • @Howtosolveprobem
      @Howtosolveprobem  8 หลายเดือนก่อน

      Thanks for the feedback ✌🏻

  • @Sirigineedi_Navann
    @Sirigineedi_Navann 8 หลายเดือนก่อน +1

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

    • @Howtosolveprobem
      @Howtosolveprobem  8 หลายเดือนก่อน

      Thanks for the feedback ✌🏻

  • @chaitanyalanka7043
    @chaitanyalanka7043 8 หลายเดือนก่อน +1

    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
      @Howtosolveprobem  8 หลายเดือนก่อน

      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
    @eduardorommeocastulolopez4814 4 หลายเดือนก่อน +1

    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
      @Howtosolveprobem  4 หลายเดือนก่อน

      @@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