Forum Discussion

vinnylad's avatar
vinnylad
Regular Visitor
3 years ago
Solved

Creating a simple table to display unrelated values

Hi All

 

Thsi is a novice request, but i just cant work out how to construct this.  I am creating a report for business consumption that requires a simple summary list of values to be displayed.   This is effectively an executive summary front page which will roll up values from all the items we are tracking in the wider PBI report for quick digestion of management. 

 

The measures displayed in the exec summary table will effectivley be unrelated to each other, so im just looking to display a custom row header / literal with an approriate measure / value alongside it (see sample image).  The measures will react to date slicer only.  The creation of the measures is not a challenge - just the displaying of them.

 

I apologise if this is 101.  Ive done my starter courses, but they seem more focused on using cool features for handling complex data, rather than displaying / formatting the arrangement of data .  Would appreciate any steer here!

 

Thanks

 

 

     

  • Sounds like you need to build a field parameter and load the measures into it. Then for Column 1 you'd put the parameter name column and the values would go in column 2

4 Replies

  • Hi vinnylad You mentioned a image in your initial post but I don't see one. Could you provide one? or a sample of what your are trying to accomplish

    • vinnylad's avatar
      vinnylad
      Regular Visitor

      ah - sorry.  I embedded an image into the request (just the simple excel style table you see under my 'thanks').  In case its not showing, ive included it again here.  So, simply column one 1 I want to put custom headers....and column 2 some custom measures.  Each row is not related to the row above or below...each of the headings / measures are kinda of stand alone.  So yeah, the sort of thing you do in 1 minute in excel and im pulling my hair out with PBI!  🙂

       

       

      • claymcooper's avatar
        claymcooper
        Icon for Resolver II rankResolver II

        Sounds like you need to build a field parameter and load the measures into it. Then for Column 1 you'd put the parameter name column and the values would go in column 2