need to make custom reports.

[guchil]

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 in advance 

Ganesh

[Greg_Deckler]

Please see this post regarding How to Get Your Question Answered Quickly: https://community.powerbi.com/t5/Community-Blog/How-to-Get-Your-Question-Answered-Quickly/ba-p/38490

[amitchandak]

Can you share sample data and sample output.

[guchil]

HI Amit

I have a student table which consists of 

Roll no	Name	Date of admission	Class
1	Dan	12-06-2001	9
2	Ron	20-06-2002	8
3	Dave	11-05-2003	7

  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

[amitchandak]

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

[v-lili6-msft]

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]

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