Need a solution idea for Migrating tableau reports into Power BI about Tableau Path (MARK Shelf)

[jishnubhattacha]

This report is developed in tableau and use Path in the chart structure. Please guide how this feature can be migrated into Power BI.

[v-sshirivolu · Accepted solution]

Hi @jishnubhattacha ,
Thanks for reaching out to Microsoft Fabric Community Forum.
To recreate the Path shelf behavior from Tableau in Power BI, the main idea is to replace Tableau's path control with a clear sequence column in your data, since Power BI connects line points based on how the axis is sorted rather than a separate Path setting like in Tableau. First, figure out what the Path field represents in your report, it might be time progression, process steps, ranking, or stages in a journey. Then make sure you have a numeric 'Path Order' column that defines the exact order those points should follow, if that order starts over for each group (like each customer or product), you can create it using a DAX ranking calculation. Use this order field on the X-axis of a Line chart, your measure on the Y-axis, and a Legend if you have multiple paths. Finally, apply Sort by Column so your stage or category follows the numeric sequence. Once that sorting is in place, Power BI will connect the dots in the same progression Tableau’s Path shelf was controlling.

[v-sshirivolu]

Hi @jishnubhattacha ,
I hope the information provided above assists you in resolving the issue. If you have any additional questions or concerns, please do not hesitate to contact us. We are here to support you and will be happy to help with any further assistance you may need.

[v-sshirivolu]

HI @jishnubhattacha ,
I wanted to check if you had the opportunity to review the information provided. Please feel free to contact us if you have any further questions

[Thejeswar]

Hi @jishnubhattacha ,

We may need much more context and sample data to answer questions like these.

To want your question answered quickly, suggest you take a look at this link 

https://community.fabric.microsoft.com/t5/Desktop/How-to-Get-Your-Question-Answered-Quickly/td-p/144...

Regards,