Forum Discussion

Icon for Helper V rank

Helper V

6 years ago

Solved

create new table an visuali it with a visula

I have created the following table and I would like visualize each columns with a visual "table" but it doesn't work

#Margin_Table = DATATABLE("Mounth",STRING,"Margin",CURRENCY

,{

{"Jan","100",

{"Feb","200",

{"Mar","300"

}

)

Can you help me?

v-easonf-msft
6 years ago
Hi , AlessandroBet
If your data source is a dataset on the powerbi service,that is equivalent to the connection mode of liveconnect and you cannot create a calculate table or calculate column.

https://docs.microsoft.com/en-us/power-bi/desktop-directquery-about#live-connections

You also can refer this related article:
https://docs.microsoft.com/en-us/power-bi/desktop-report-lifecycle-datasets#limitations-and-considerations

Best Regards,
Community Support Team _ Eason

5 Replies

Greg_Deckler
Community Champion
6 years ago
I believe you want:

#Margin_Table = DATATABLE("Mounth",STRING,"Margin",CURRENCY ,{ {"Jan",100}, {"Feb",200}, {"Mar",300} } )
- AlessandroBet
  Helper V
  6 years ago
  Yes sorry i did a mistake typing. Anyway it doesn't work
  - v-easonf-msft
    Community Support
    6 years ago
    Hi , AlessandroBet
    You also can refer here.
    And could you please tell me whether your problem has been solved?
    If it is, please mark Greg_Deckler replies or add your reply as Answered to close this thread.
    
    Best Regards,
    Community Support Team _ Eason
    If this post helps, then please consider Accept it as the solution to help the other members find it more quickly.