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. šš
Dynamically resizing bubbles based on data values on powerbi
Hi everyone, Iām building a fruit-inventory dashboard and want to show each stage of our banana supply chain as a bubble. For example: Harvested Bananas: 10 crates In Transit: 80 crates Delivered: 50 crates Each stage is represented by a bubble, and Iād like the bubble size to grow or shrink automatically according to the countāso āIn Transitā would appear largest when it has 80 crates, and āHarvestedā smaller with only 10. I previously tried the Akvelon Power BI visual, but I couldnāt get the bubble size to respond dynamically to the measure. The layout should display the stages sequentially (1-2-3ā¦) while each bubble scales with the underlying data. Whatās the best way to achieve this in Power BI? Would you recommend a custom visual, a DAX measure trick, or another built-in visual? Any guidance or examples would be greatly appreciated. Thanks,
Bar Chart Categories Not showing when data filtered.
Good morning everyone. I'm producing a bar chart to show discrete data. The output of machines. We have 12 machines and I would like to see the data for all machines even if zero. I have selected "show items with no data" and also put +0 to the end of the calculation. When I choose a large time scale filter on the visualisation . E.g year , all 12 machines data is visible. However I report on data from the previous working day. If those machines haven't been used in the previous working day. I'm struggling how to include a value of zero also. Appreciating anyones help .
How to replace the value of x-axis based on another column
Given the data below: Column1 Column2 Value A_001 Alex 50 A_002 Alex 80 A_003 Betty 70 I am creating a column chart based on the data above. I put Column1 as my X-axis and Value as my Y-axis. However, I do not want the X-axis value to show as A_001/A_002. I would like it to show the name such as Alex in Column2. I cannot put Column2 as my X-axis because there are chances of identical values as shown in the table, which will merge and stack up the value by Power Bi. Can anyone advise?
