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,
Need a Dax to make a measure for counting the rows on a dynamic table using 2 parameters [Power BI]
The Row count needs to be displayed on a Key card next to the table visual. The Data of the Table is from two Parameters (Multi-selection) : 'Selected Dimensions P3'[Select Dimensions] 'Selected Measures P3'[Select Measures] Rows on the Table keeps changing according to the field selection by the viewer. The row count on the key card should simultaneously change to the current number of rows displayed on Table Visual.
Add Visuals to PowerBI report using API
We are doing consolidation of reports and workspaces in our organization for which i need to migrate several reports from one workspace to other. I want to insert a button or link into all the old reports which navigates user to newly migrated report. As this is a very big effort to do manually for all the reports, I am trying to see if I can achieve the same by using PowerBI Rest API or PowerShell modules. Is this functionality acheivable ? If so can someone help me guide to achieve the same
Date Range based on Slicer selection
Hello - I'm looking to return a list of the previous "X" days based on a selected day from a slicer. For example, once a day is selected in the 'Date' slicer, I want to return the date range in the visualization for the previous 180 days up to the selected day. In simple words, the logic would be something like the below, but I cannot make it work: IF ( Date >= SELECTEDVALUE ( Date )-180 || Date <= SELECTEDVALUE ( Date ) , Date , blank() ) And then use 'Date' in the visualization and exclude blanks. Any recommendation is more than welcome, thanks!!Best Type of chart to represent avg, below avg, and above avg
Hi folks! I'm asked to prepare a chart that represent the average score for groups of people and show as well how many of them scored above average and how many scores below average. What's the best way to represent these info without looking messy and complicated for the end user? note that i have +4 groups
