@ excel table

2 Topics

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
532Views
0likes
1Comment