Forum Discussion

jishnubhattacha's avatar
7 months ago
Solved

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

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

  • Anonymous's avatar
    Anonymous
    7 months ago

    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.


4 Replies

  • Anonymous's avatar
    Anonymous
    Not applicable

    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.


    • Anonymous's avatar
      Anonymous
      Not applicable

      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.

       

      • Anonymous's avatar
        Anonymous
        Not applicable

        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