Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏Visualising a process flow
Hi there. I'm new to PowerBI and trying to visualise (graphs and tables) the performance of a process over time, eg the trends by week of how much "value" moves through about six steps of a process from identifying a potential sale through the selling then delivering then billing. The data I have is in two tables: a sales table with the dates that each unique sales opportunity moves from step one to step two etc, and the value is the monthly recurring revenue that it will be once delivered. The second table (delivery table) breaks the sales order into a number of services, that each then have a delivery date and a "first billed" date. The output I'm hoping to build is for example: This week, $20k worth of value was identified ie entered the first step of the process, $50k moved from step 1 to step 2, $30k moved from step 2 to step 3 etc. And therefore at the end of the week, $200k was sitting in the WIP bucket that had moved from step one to step two, but hasn't yet moved to step three. What's the best way to visualise this, and what do I need to do to my data tables for it to work, including beinf able to filter by product, by sales person etc? Thanks for your help.
