@ excel table

4 Topics

Selecting cells, copying / pasting from Power BI into Excel
Hi there, I am new to Power BI. I am an end user and need the data displayed in Power BI to obtain data and write reports. I feel frustrated because there appears to be no easy way to drag and select tables, or multiple cells in a table, to copy and paste in the same format in excel. If I copy the table, the format it is pasted in in Excel is very difficult to sort out. If there are multiple slicers, I seem to have to copy the table for each individual slicer separately to get the data in excel. Is there not an easier way to export the data in excel exactly as displayed in Power BI? Or even a way to quickly select cells in the table to copy / paste? I am using Power BI Report Server, not the Desktop app.
Solved
canost
1 year ago Place Report Server
2.2KViews
0likes
4Comments
Dynamic formatting not showing the correct currency in Excel
Hi team, I am using the dynamic formatting for a switch measure to ensure to display the data in correct format according to the selected measure. It works all fine until I visualise the data in Excel. I get £ sign instead of $ sign. Here is the dynamic formatting code: SWITCH( TRUE(), [SelectedMeasure] = 1, "$#,##0", // Revenue [SelectedMeasure] = 2, "#,##0", // Units [SelectedMeasure] = 3, "#,##0", // Accounts [SelectedMeasure] = 4, "$#,##0", // ADS Revenue [SelectedMeasure] = 5, "#,##0", // ADS Units [SelectedMeasure] = 6, "$#,##0", // Revenue On Pace [SelectedMeasure] = 7, "#,##0", // Units On Pace [SelectedMeasure] = 8, "$#,##0", // ASP [SelectedMeasure] = 9, "#,##0", // Units / Account [SelectedMeasure] = 11, "0%", // IVL/PCI% [SelectedMeasure] = 12, "0%", // IVL/ROTA% [SelectedMeasure] = 13, "$#,##0", // Revenue (actual fx) [SelectedMeasure] = 14, "#,##0", // Units Coronary [SelectedMeasure] = 15, "#,##0", // Units Peripheral [SelectedMeasure] = 16, "#,##0", // Orders [SelectedMeasure] = 18, "$#,##0", // Revenue Coronary [SelectedMeasure] = 19, "$#,##0", // Revenue Peripheral [SelectedMeasure] = 20, "#,##0", // Units FOC [SelectedMeasure] = 21, "0%", // Units FOC % [SelectedMeasure] = 22, "0%", // C2/PCI% [SelectedMeasure] = 23, "0%", // C2/ROTA% "General" // Default format ) I tried adding FORMAT([SelectedMeasure]) but it returns wrong results. Kindly advise, Best regards, Hugo
Solved
treatas
1 year ago Place DAX Commands and Tips
1.2KViews
0likes
2Comments
Printing content of web link in power bi table [ column] in one go
I have use case , A table has column mnamed LINK. it hold https link to a pdf content. there will be more rows in table with link as column. I am trying find solution to have button [ one click] does below. 1. Iterates all the links in LINK column 2. hit the link and get the PDF content one by one 3. Send the pdf to printer. How can i achieve this ?
SangameshW
2 years ago Place DAX Commands and Tips
529Views
0likes
1Comment
Importing file from a server vs. desktop
I'm trying to create new query importing from excel table, not from excel sheet. First, I created and named "table1" as below. (No Prob.) Then, once I uploaded the excel file on "Power BI Server", and imported the file to a new query, I couldn't find "table1" that I just made. (Problem!!) So I tested by importing the file from my desktop directly, then I found "table1" and 3 more columns (No Prob.) ※ The Question is : 1. Why the commands from the server & desktop call different items and colums? 2. Is there any way to call "table1" importing data from the server?
SanCho1
2 years ago Place Report Server
629Views
0likes
2Comments