Forum Discussion

Mtozero's avatar
Mtozero
Helper I
8 years ago
Solved

Power BI Table In the UI

We have a requirement to display the data in power BI with the below format.    (a) Columns as Rolling 12 months,(show individual month), Previous 12 Months overall total, Current 12 Months and the...
Need Help
Mtozero's avatar
Mtozero
Helper I
8 years ago

Thanks, freder1ck, Appreciate your quick response. 

 

Do we have any options to dynamically change the column Name of the table?   

 

freder1ck's avatar
freder1ck
Kudo Kingpin
8 years ago

Thank you! 

 

When you say dynamically change the name of the column name, what exactly do you mean?

 

The column names of the Report table are set when the data is refreshed.

 

The current month (offset value 0) is 12/31/2017. In a few days, the current month will be 1/31/2018. 

 

It looks like I put the wrong link in to my personal OneDrive. I'll put the link up after work today.

 

Fred

 

 

 

    • Mtozero's avatar
      Mtozero
      Helper I
      8 years ago

      thanks freder1ck for your response. Appreciate your support. 

       

      My problem is with the disconnected table since we need to more slicers. 

       

      So what I was thinking let's assume there is no disconnected table. If I can add 12 measures (DAX for each month). It might work but the problem is how to make the measure name/column name dynamically changing.

       

      • freder1ck's avatar
        freder1ck
        Kudo Kingpin
        8 years ago
        Mtozero wrote:

        thanks freder1ck for your response. Appreciate your support. 

         

        My problem is with the disconnected table since we need to more slicers. 

         

        So what I was thinking let's assume there is no disconnected table. If I can add 12 measures (DAX for each month). It might work but the problem is how to make the measure name/column name dynamically changing.

         


        Could you describe a bit more the final result you're looking for? The results here can be sliced by Country, Territory, etc. You could even add a slicer on the disconnected table to show only specific columns. Are you looking to slice according to year and month instead of current state?