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. 😊🙏Visualise distributions with pre-summarised data
G’day everyone, New user of Power BI and first-time poster. I want to know how I can create a visualisation of key distribution statistics (e.g. minimum, first quartile, medium, third quartile and maximum) using data that has already been summarised? For example, consider the data example in the first screenshot below. I can use excel to show these statistics as a box and whisker plot that dynamically responds to the filters I’ve applied (see second screenshot below). Is it possible to do something similar in Power BI? The only non-negotiable constraint is that the data is already summarised (like the example in the first screenshot). The visualisation doesn’t have to be a box and whisker plot, just something that highlights the distribution. The structure of the data set can also be different (e.g. the summary statistics can be restructured as columns rather than rows as they are in the example attached). Thanks in advance for all your help! PS: This forum would be even better if members could post files so responders had access to sample data or other reference material.
