Forum Discussion

xiumi_hou's avatar
xiumi_hou
Icon for Post Partisan rankPost Partisan
6 years ago

Need Help: How to design metric table

Dear all,

 

I need help to generate some thoughts about this metric table.

1. First How can I remove the first column ‘ATTRIBUTE",which is what I put under ’row"

2. My idea is to show each question, what is the trend of their score by date, do you have any idea how should I design this table? Or other though than table is also good. Thanks

5 Replies

    • v-lid-msft's avatar
      v-lid-msft
      Icon for Community Support rankCommunity Support

      Hi xiumi_hou ,


      How about the result after you follow the suggestions mentioned in my original post?Could you please provide more details about it If it doesn't meet your requirement?

       

      Best regards,

      Community Support Team _ Dong Li
      If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.

      • xiumi_hou's avatar
        xiumi_hou
        Icon for Post Partisan rankPost Partisan

        v-lid-msft  Thanks for answering. I just tried the first one, I only want to show the last column "Total score" by each question. The question is I have colorful picture as background.

         

        Do you think I create 9 measures and make the 9 measures combine to one column is a good solution or do you have any other suggestions? Thanks!

  • v-lid-msft's avatar
    v-lid-msft
    Icon for Community Support rankCommunity Support

    Hi xiumi_hou ,

     

    For first question, If you want to hide the row, we can put a blank text box on it like following picture:

     

     

    For the second question,  We can use the Line chart if you want to show the trend based on the time.

     

     


    If it doesn't meet your requirement, kindly share your sample data and expected result to me if you don't have any Confidential Information. Please upload your files to One Drive and share the link here.


    BTW, pbix as attached.

     

    Best regards,

    Community Support Team _ Dong Li
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.