Microsoft Sankey Visual: How can I prevent destination nodes being automatically reordered?
Hi all, I'm using the Microsoft Sankey visual in Power BI Desktop and would like to keep the node order consistent between the left and right sides of the chart. My source data is structured as: From To Value Apples Apples 45 Apples Pears 7 Pears Fig 26 Fig Cherry 115 Cherry Cherry 13 Intended category order: Apple Pear Fig Cherry However, the Sankey visual automatically changes the order of the destination nodes presumably to reduce flow crossings. I have already tried: Creating a numeric sort column (1 = Severe, 2 = Moderate, 3 = Mild, 4 = Normal renal function) Using Sort by Column on the destination field (To) Creating a separate Category/SortOrder lookup table Sorting both the source data and lookup table correctly Disabling Auto links reorder in the visual settings Power BI accepts the sort order without errors, but the Sankey visual continues to reorder the destination nodes. Manually dragging is not ideal, as the freehand movement does not allow precision. My questions are: Does the Microsoft Sankey visual support a fixed destination node order? Is there a supported way to force the same category order on both sides of the Sankey Any advice would be greatly appreciated. Thanks!
Power BI Custom Visuals' Community
Welcome to Power BI Custom Visuals Community! Power BI custom visuals is all about community. We are very excited to announce that custom visuals now have a special place in the Power BI community site, to share knowledge, ideas and news! Custom visuals development discussion – Ask questions and share knowledge about developing custom visuals. Custom visuals ideas – Share your ideas, ask for features, propose new custom visuals. Custom visuals community blog – Community news and announcements for new custom visuals available, new APIs released, tips & tricks from developers and users. Power BI custom visuals useful links for developers Developer documents - find here all documents you need Step-by-step tutorial Looking for advanced tutorial? Find it here Visit also our github Find here Power BI visuals' Samples Custom visual's webinar For technichal questions and help please reach out [email protected]
Power BI Custom Visual: Customize series mechanism example
As per this: https://powerbi.microsoft.com/en-us/blog/introducing-the-new-format-pane-preview/ Is there an example on how to get the customize series mechanism. In my formatting pane I am getting the options succeffully in the dropdown and in the formattingSettings object. But they are not updating. Return formattingSettings: { "columnWidth": { "container": { "displayName": "Apply settings to", "containerItems": [ { "width": { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" }, "name": "row_0", "displayName": "work_year", "slices": [ { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" } ] }, { "width": { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" }, "name": "row_1", "displayName": "job_title", "slices": [ { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" } ] }, { "width": { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" }, "name": "value_0", "displayName": "Sum of salary_in_usd", "slices": [ { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" } ] }, { "width": { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" }, "name": "value_1", "displayName": "RR", "slices": [ { "name": "width", "displayName": "Column Width", "description": "Set the width of this column (pixels)", "value": 120, "options": { "maxValue": { "type": 1, "value": 1000 }, "minValue": { "type": 0, "value": 20 } }, "type": "NumUpDown" } ] } ] }, "name": "columnWidth", "displayName": "Column Width" } } This is what I code have implemented: - capabilties.json: object: { "columnWidth": { "displayName": "Column Widths", "properties": { "width": { "displayName": "Column Width", "description": "Set Column Width.", "type": { "numeric": true } } } } } - Settings.ts: import powerbi from "powerbi-visuals-api"; import { formattingSettings } from "powerbi-visuals-utils-formattingmodel"; // Column Width Card for per-column dropdown export class ColumnWidthCardItem extends formattingSettings.SimpleCard { public width: formattingSettings.NumUpDown = new formattingSettings.NumUpDown({ name: "width", displayName: "Column Width", description: "Set the width of this column (pixels)", value: 120, options: { maxValue: { type: powerbi.visuals.ValidatorType.Max, value: 1000 }, minValue: { type: powerbi.visuals.ValidatorType.Min, value: 20 } } }); constructor(name?: string, displayName?: string, widthValue?: number) { super(); this.name = name || ""; this.displayName = displayName || name || ""; if (typeof widthValue === "number") { this.width.value = widthValue; } this.slices = [this.width]; } } class ColumnWidthCardSetting extends formattingSettings.SimpleCard { public container: formattingSettings.Container = { displayName: "Apply settings to", containerItems:[new ColumnWidthCardItem()] }; constructor() { super(); this.name = "columnWidth"; this.displayName = "Column Width"; } } // Main Settings Model /** * Main settings model for the Power BI visual formatting pane. Contains all formatting cards and option groups. */ export class VisualSettingsModel { columnWidth: ColumnWidthCardSetting; cards: Array<formattingSettings.SimpleCard | formattingSettings.CompositeCard>; constructor() { this.columnWidth = new ColumnWidthCardSetting(); this.cards = [ this.columnWidth ]; } } -visual.ts: this.formattingSettings = this.formattingSettingsService.populateFormattingSettingsModel(VisualSettingsModel, dataView); // Dynamically create per-column width cards for the formatting pane using formatted columns if (dataView && dataView.matrix) { const formatted = formatMatrixForFGGrid(dataView.matrix); console.log("Formatted: ", formatted) const formattedColumns = formatted.columns || []; const fieldWidthCardItems = formattedColumns.map((col: any) => { // Use col.index for name and col.title for displayName let widthValue = 120; if (this.formattingSettings?.columnWidth?.container?.containerItems) { const match = this.formattingSettings.columnWidth.container.containerItems.find((item: any) => item.name === col.index); if (match && match.width) { widthValue = match.width.value; } } return new ColumnWidthCardItem(col.index, col.title, widthValue); }); console.log("fieldWidthCardItems: ", fieldWidthCardItems); // Set the containerItems array on the formattingSettings model if (this.formattingSettings?.columnWidth?.container) { console.log("Updating columnWidth with formatted columns."); this.formattingSettings.columnWidth.container.containerItems = []; this.formattingSettings.columnWidth.container.containerItems.push(...fieldWidthCardItems); console.log("formattingSettings: ", this.formattingSettings); } }
REMOVE/SELECT ALL VISUAL INTERACTION WITH ONE BUTTON! PT/US
US Hello everyone, everthing right? Would be amazing if exists a button where we can remove all interaction of wish slicer; filter and another things. Because, removing one by one interaction in a giant dashboard is soo massive, this suggestion will be save a great time in workflow, i really believe! I create a prototype of this suggestion below. I hope that this feature will be implemented in the near future. PT Olá a todos, certo? Seria incrível se existisse um botão onde pudéssemos remover todas as interações do filtro de desejos, filtro e outras coisas. Porque remover uma a uma as interações em um painel gigante é muito trabalhoso, essa sugestão economizaria muito tempo no fluxo de trabalho, eu realmente acredito nisso! Criei um protótipo dessa sugestão abaixo. Espero que esse recurso seja implementado em um futuro próximo.Why does the Emissions Impact Dashboard stay on sample data after setup?
Hello, I followed the instructions in the article: Connect to the Emissions Impact Dashboard for Azure - Power BI | Microsoft Learn I installed the Emissions Impact Dashboard for Azure and, as described in the steps, I entered the billing account ID from Connect your data. My account has already been assigned the Billing Account Owner role. However, my Azure environment is a free trial, not an Enterprise Agreement subscription. After that, the “Connect your data” button disappeared, which made it look like the connection succeeded. But the dashboard content still only shows the sample data. The documentation says: "Wait for the view to build, which can take up to 24 hours. Refresh the dataset after 24 hours." I waited more than one day, but nothing has changed. Additionally, this might not be related, but when I go to the Manage data tab and click Delete data > Confirm, I get redirected to the page shown in the third screenshot. Why am I unable to see my own Azure emissions data in the dashboard? What could be the issue? (Could it be because my environment is a free trial, not an Enterprise Agreement?) If anyone knows the cause or any workaround, I would greatly appreciate your advice.
Scatter plot of Standard deviation adding legend filter
Hi! I am attempting to plot test data for numerous samples. I am trying to plot standard deviation of a certain value vs another field and add the test sample to the legend, so I can filter out the samples. When I add the the sample test to the Legend it plots the standard deviation as all zeros. I have confirmed this is not the case. Any suggerstions? I've tried scatter plots and line plots.Modal Dialog API 3.8.1
Greetings all, I've experimented with the new feature that came with new API and I ran into some issues (see attached image). Has anybody been succesful in implementing a modal dialog? A small example from which I could extrapolate would mean the world to me. 🙂 Thanks in advance, Dusan
How to exclude a parameter filter/Name from one of my charts
Hi all, Power BI question I have situation where I have a pararameter set up param1 = { Name,nameof('dictionary'[Name]),0), { station,nameof('dictionary'[station]),1), { title,nameof('dictionary'[title),2) The parameter selection works and filter's as they should, however for the stacked column chart, I would like the Name parameter not to appear on the stacked bar chart and rather default to another default view on the bar chart. The reason for this when I click the name selection, I have over 300 names and that is an overwhelming look on the x-axis and has no use visualing for what i am trying to achieve. so below is a recreation of what i am workin on in Power BI. So when I select name on my drop down (powered by the parameter). I would like only the table to be affected by the change and the chart to ignore showing name as the x - axis dimension. so here if i selected name the table would list all the columns, but the chart would default and or stay in a view that shows thw count of stations by title. this is the view when station or Title is selected. Name does not appear on the table.Limiting data on different levels
I have item/purchase order level data in a single query. I want to be able to select a single item from the top table, and have it show me all of the items that are on that same PO. I got it to work by making a duplicate of the query, but I was wondering if there was a way of selecting data from a table that would limit the data in another table, but at a different level. In this screenshot, I have PO 00159156, item AC0051 selected, and the bottom visual showing all of the items on PO 00159156. Like I said, to make this work I have to load the PO query twice in two seperate table and create a relationship on Order number. Is there a better way to do this?
