Forum Discussion

guchil's avatar
guchil
Regular Visitor
6 years ago

need to make custom reports.

HI all, Wanted to custom BI like student Name: abc Student Class: 1st    where Student Name: is a label and abc from DB how to i add label feild cn any one please help in the same.   Thanks ...
amitchandak's avatar
amitchandak
Icon for Super User rankSuper User
6 years ago

Can you share sample data and sample output.

guchil's avatar
guchil
Regular Visitor
6 years ago

HI Amit

I have a student table which consists of 

Roll noNameDate of admissionClass
1Dan12-06-20019
2Ron20-06-20028
3Dave11-05-20037

  Expected report (i am basically trying to rewrite my crystal reports to power bi)

on passing the roll no should be getting thesr values. the label feild will have custom texts not the name on the column 

                                   ABC School                                               
Student Name(these are labels ) Dan
Class(these are labels )  9
  • v-lili6-msft's avatar
    v-lili6-msft
    Icon for Community Support rankCommunity Support
    6 years ago

    hi  guchil 

    I'm a little confused on your expected output.

    Do you mean if you selected Roll no=3 then show like  it.

    What is custom texts not the name on the column? could you please show it more clearly with different scenarios?

     

    Regards,

    Lin

    • guchil's avatar
      guchil
      Regular Visitor
      6 years ago

      Yes if i select roll no 3 then it show accordinly.

       

  • amitchandak's avatar
    amitchandak
    Icon for Super User rankSuper User
    6 years ago

    I think it can of the custom display. Assumption Roll no is selected.

    union(
summarize(table,"ABC School","","-",""),
summarize(table,"ABC School","Student Name(these are labels )","-",max(Name)),
summarize(table,"ABC School","Class(these are labels )","-",max(Class)&"")
)

     

    summarize can replace with selectcolumns with few changes. You can try that. No need of max in case selectcolumns