No, this isn’t what I meant I’ll explain it in detail here.
I have two tables in my Power BI model:
1️⃣ Fact Table – contains columns like Country, State, City, Pincode, Product Name, Category, etc.
2️⃣ Sales Table – contains Sales Value, Store, Date, Net Profit, Store Size, and Employee Number.
My Requirement
I want to create a logic based on Sales Value bands as follows:
Top 50% → Green
Next 20% → Yellow
Remaining 30% → Red
The goal is to plot these bands dynamically based on the group or filters applied, and then superimpose the store-wise sales value over the bands.
For example:
If I have store-wise sales data across multiple states and I select California → Los Angeles, out of thousands of data points only 100 stores may appear.
Now, for those 100 stores:
The top 50% (highest sales) should form the Green band,
The next 20% should form the Yellow band,
The remaining 30% should form the Red band.
Based on these, I’ll have minimum and maximum values for each band (Green, Yellow, Red), which will define my band zones.
Additional Requirement
Once I get these bands using DAX, I also want to:
Superimpose the Sales Value of any particular store on top of these bands — so I can easily see where that store lies.
Ideally, I’d like to compare multiple stores at once (e.g., two or more) to visualize how they perform relative to the defined bands.
The important part is that the bands must be redefined dynamically based on the filters applied.
For example, if I apply an additional filter like “Employee Number > 3”, then the bands should recalculate automatically for the filtered dataset.
As of now, I can successfully plot the bands, but I’m unable to superimpose the Sales Value over them.
I’d really appreciate your support or guidance on how to achieve this part.
