User Profile
jar2019
Helper I
Joined 7 years ago
User Widgets
Contributions
Best Choice Dot Plot
Hey guys, I am looking for a dot plot visual that I can use for risk mapping. Likelihood on the x impact on the y and a score as the size of the dot. The issue I am having is that I only what to view my top ten risks by score and many of the risks have the same impact and likelihood so they hide behind each other and I can only view the topmost dot. Do you have a recommendation for a dot plot visual that shows all values on a given coordinate on the x-y plot? sample: Risk Score Impact Likelihood 136 25 5 5 182 25 5 5 209 20 4 5 199 15 5 3 102 10 5 3 Notice that risk 136 and 182 will be on atop the other so when you are visualizing you only see one and not both. Same with 199 and 102, they have different sizes but when plotted will plot on atop the other only allowing the end user to see one of the two and not both. A visual that perhaps was dynamic and moved the dots so you could see all of the dots on a coordinate (e.x. (3,5)) would be great. Any other suggestions are welcome.599Views0likes1CommentRe: Paginated report builder!!
MS is throwing around the idea to open up publishing reports builder (RDL) files for PRO users. Currently this is only available for premium which is such a bummer. Vote here https://ideas.powerbi.com/forums/265200-power-bi-ideas/suggestions/37913800-allow-pro-users-to-publish-rdl-files-from-report-b5.5KViews0likes0CommentsRe: New update June 2019 - Query Error
I had the same issue and here is how I fixed it: 1) Go into the query editor and click on edit source. 2) click change source 3) You just have to copy the workbook URL and paste it back in. I had to do for every single file that I was referencing so it took me a hot minute. Then refresh. If it still doesn't work (Which I didn't have luck the first time) Try changing the permission and signing back into your SharePoint account with your Auth method. Then follow the steps aboce.2KViews0likes1CommentRe: New update June 2019 - Query Error
from SharePoint? What is the source? sajarac wrote: Hi There, Could someone please confirm if with the new update it is creating a mess in the querys? I have two PC's one with previous build and the file loads the querys without any issue, but with this update I am getting this: Version: 2.70.5494.562 64-bit (June 2019)2KViews0likes3CommentsRe: Option for user to hide and display tabs/pages
I use bookmarks and the selection pane (under view tab). Then I create buttons that are bookmarks to the various tabs or pages. You can create multiple pages in the report (some for each type your users might want) All you have to do it right click the tab on the bottom and click hide. Then you can create a menu (just a bunch of buttons that are links to the different pages). Essentially this lets you guide the users to pages you want them to see while hiding the rest. It doesn't allow them to see the tabs at the bottom, but in my opinion the menu option is more modern and creates a more engaging end-user experience. Anonymous wrote: Hi, My report has two segments which is not related (In my case Asset Management Industry and Asset Servicing Industry). On the first page of the report I want to give the user an option/button to select which industry he is interested in. So when the user clicks "Asset Management", he can see and navigate through the pages/tabs for asset management analysis only (while those of the other industry are hidden automatically), while if he click on "Asset Servicing", the tabs for asset management are hidden and he can see and navigate through asset servicing tabs. Not sure if this is possible.15KViews0likes0CommentsRe: Option for user to hide and display tabs/pages
A combination of using bookmarks and the selection panel Anonymous wrote: Hey Anonymous You can hide tabs. And use bookmarks for navigation. Try this. Good Luck! A to hide visuals based on the button the user clicked. It can get complex the more visuals you are adding and hiding so be sure to take the time to organize them in the selection pane.15KViews0likes0CommentsRe: Create new column for measure?
I see: 1) right click anywhere in the table dropdown on the right. 2) click quick measure (also in the ribbon on home->top right) 3) use the dropdown in the quick measure pop up to select your operation So you need to create a total by category measure first (this will be the sum of all your columns) by state Then you can create another quick measure that divides the "total measure" we just created by the columns Tru, Fals, Etc. using the division operator. You can also create a new column but this can take up a lot of space if you have a lot of records. You could also use DAX and use the "measure" instead of "quick measure" Measure Total = SUMX('Table','table'[False]+'Table'[True]...etc)1.4KViews0likes0CommentsRe: Allow users to build new content using the underlying datasets
This is a feature with the new workspace. Essentially if you have shared your workspace with someone they can use the power bi dataset source and grab your dataset and use it. But, if security is a concern then they shouldn't be given access to your workspace to begin with. (Not sure if that is why you are asking) Just search the documentation on power bi dataset and its application. Arnaud_R wrote: A new feature is now possible to select when sharing a report : Allow users to build new content using the underlying datasets. What is the status for the previously shared reports ?10KViews0likes0CommentsRe: Report update
I was having some weird issues with SharePoint files last week. Check The query editor on power BI desktop and see if any of the datasets are failing to load due to auth issues. If so, you just have to click the edit datasource and re-copy the path to the datasets. This somehow resets it and it starts working again.831Views0likes1Comment
Data Privacy
Microsoft Fabric Community and Privacy
To learn more about how we manage your data, please review the Microsoft Fabric Community Data Privacy guide.