How to show both count and total price with Date Slicer?

[Marneil2216]

I’m working on a Power BI report and using a Sankey diagram with ChartExpo Sankey, Visio Chart Sankey, and Microsoft Sankey (from AppSource).

I want the Sankey to display both the count of items and the total price for different phases such as:

-Awarded
-Bid Phase
-Budget Phase
-Lost
-Re-Bid Phase

Current issue:
The visual only allows me to use one measure (either count OR total price).

What I need:
✔ Show both count and total price in the Sankey diagram (for example: Count: 15 | Total Price: $50,000).
✔ When I use a date slicer, the Sankey should update dynamically based on the selected date range.

Questions:

Is there a way to show two measures together in a Sankey diagram?
Or create a combined DAX measure to display both count and total price in one field?
How can I make sure the Sankey responds to the date slicer filter?
Any ideas, DAX formulas, or best practices would be greatly appreciated.

Thank you!

[Shahid12523 · Accepted solution]

Sankey supports only one numeric measure (flow thickness).

Use Total Price (or Count) for the weight.

Create a combined DAX measure for labels/tooltips:

Count_TotalPrice =
"Count: " & COUNTROWS(YourTable) &
" | Total: $" & FORMAT(SUM(YourTable[Price]), "#,##0")

Add this measure as node label/tooltip.

Make sure your Date table is related → the slicer will filter both Count & Total dynamically.

✅ Best: Use Total Price for flow + show Count in label/tooltip.

[v-karpurapud]

Hi @Marneil2216 

Just checking in as we haven't received a response to our previous message. Were you able to review the information above? Let us know if you have any additional questions.


Thank You.

[v-karpurapud]

Hi @Marneil2216 

We have not received a response from you regarding the query and were following up to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions.

Thank You.

[v-karpurapud]

Hi @Marneil2216 

I wanted to check if you’ve had a chance to review the information provided. If you have any further questions, please let us know. Has your issue been resolved? If not, please share more details so we can assist you further.

Thank You.

[v-karpurapud · Accepted solution]

Hi @Marneil2216 

Thank you for reaching out to the Microsoft Fabric Community Forum.

Currently, It is not possible to plot two separate measures as flow weights in a Sankey visual, since the visual can only use one numeric value to determine thickness. The recommended approach, as highlighted by @Shahid12523 ,is to create a combined textual measure that concatenates both Count and Total Price and use it as the display label or tooltip. This allows users to see both values alongside the flows while keeping the visual clean and meaningful. Provided that your Date table is properly related to the fact table, the slicer will automatically filter both measures and update the Sankey dynamically. As a best practice, use Total Price as the flow weight to reflect monetary impact, and display the Count within the label or tooltip for added context, ensuring the visual remains accurate, clear, and user-friendly.

I hope this information is helpful. . If you have any further questions, please let us know. we can assist you further.

Regards,

Microsoft Fabric Community Support Team.


 

[Marneil2216]

Hello, Apologies for the late reply, I’ve been busy recently. Thank you for your guidance. I’ve applied the suggested solution using Total Price as the flow weight and concatenating Count and Total Price in the label/tooltip. Everything is now working as expected, and the slicer filters are updating both measures correctly.

I really appreciate your support!

Best regards,
Marneil

[Shahid12523 · Accepted solution]

Sankey supports only one numeric measure (flow thickness).

Use Total Price (or Count) for the weight.

Create a combined DAX measure for labels/tooltips:

Count_TotalPrice =
"Count: " & COUNTROWS(YourTable) &
" | Total: $" & FORMAT(SUM(YourTable[Price]), "#,##0")

Add this measure as node label/tooltip.

Make sure your Date table is related → the slicer will filter both Count & Total dynamically.

✅ Best: Use Total Price for flow + show Count in label/tooltip.

[Marneil2216]

Thanks Shahed! I applied your solution and it’s working perfectly now.