code

8 Topics

Embeeded report visibility
Hello, I have one question becasue would like to be sure that I understand correctly. If I use an option Embed the report -> publish on the Internet I will get a warning window which inform that the report can be shown also in other pages. My question is: does the Microsoft has an access to this report, can display it somewhere or it is possible from them only if I will share the embeeding code? Is it public by the definiton or I do have to share a code? I'd like to create an code and put it only in our company's Intranet
Solved
Anonymous
2 years ago Place Report Server
2.2KViews
0likes
6Comments
Dax Variance and percentage computation code.
What is the code for these. I want to have. 1. Variance/ending balance. between Total delivered vs Total Sales 2. Percentage % Thank you so much.🙏🏻
Solved
JanCen
3 years ago Place DAX Commands and Tips
644Views
0likes
1Comment
How to hide power query code after publishing
Dear all, I have to publish a Power BI report in a workspace shared by my team members , so we all have "Administrator" profiles while the end users have "Member" profile. My objective is to share the dashboards and Data tables (DAX part of the report), but I want to make sure that the query part "Power query" is not visible by any of the users whatever the profile, is this possible? Many thanks in advanace for your help 🙏
Solved
Betty888
3 years ago Place Report Server
890Views
1like
1Comment
wrie JS code
Hello How can run JS code in power bi? Can it be run in custom visuals? or just with API ?
MaryamBaghi
3 years ago Place Custom Visuals Development Discussion
7KViews
0likes
4Comments
Dynamic Message using the system username
Hi there! i have this code which consists of making a greeting to the person who enter the dashboard, how do I get the system username printed on the message? like.. if the system is called "John Computer" I want the message to appear "Good afternoon John Computer, is that's possible? Welcome Text = VAR Hour = HOUR(NOW()) VAR Greeting = SWITCH( TRUE(), Hour >= 0 && Hour < 5, "Good Night", Hour >= 5 && Hour < 12, "Good Morning", Hour >= 12 && Hour < 18, "Good Afternoon", Hour >= 18 && Hour < 24, "Good Evening" ) RETURN Greeting & " Murilo"
Solved
Anonymous
4 years ago Place DAX Commands and Tips
1.8KViews
0likes
6Comments
analyze last filtered data
If I filter for example 04/14/2022 to 04/17/2022 it should show me the last consumption on 04/15/2022 and the penultimate on 10/01/2022 but when performing such a filter it does not show the penultimate application of 10/ 01/2022
Anonymous
4 years ago Place DAX Commands and Tips
511Views
0likes
1Comment
Calculated column taking a count fixed to a country column
I would like to make a column or measure which takes my country column and return a number of houses in a certain colour. For instance I have 23 yellow houses in my dataset in US and 14 yellow houses in Poland A: Country column (e.g. Poland, United States) B: Colour of house (e.g. Red, Yellow) My wish i to get this out: COUNTRY (Count of yellow houses) United States (23) Poland (14) In tableau I would use a count and a FIX logic, i wonder if powerBI is able to make counts fixed to a specific country i a column
KristofferAJ
4 years ago Place DAX Commands and Tips
1.9KViews
0likes
7Comments
The CODE() Function - where is it?
I am wondering if I am going mad here...? 🙂 Trying to create a calculated column using the CODE() function, but it doesn't seem to exist! FirstCharCode = CODE(Family[GetString]) -- gives me an error - failed to resolve name 'CODE' and intellisense doesn't return it. So I look it up at - https://docs.microsoft.com/en-us/dax/code-function-dax It has not been withdrawn - anyone got any thoughts on this? I am using March 2020 PBI Desktop version. Thanks!
Solved
Anonymous
6 years ago Place DAX Commands and Tips
842Views
0likes
2Comments