Help - Building a 'Table' with Deneb that Mimics Power BI's Sort Function"
Hi Folks, Ever since I discovered Deneb a few months ago, I've been over the moon with how it broadens Power BI's capacity and amplifies its visual prowess so impressively. It's truly a game-changer 🙂 Yet, as I explore further, I've stumbled upon a challenge that I am confident can be addressed by the minds here 😉 . I'm attempting to build a Power BI "table like" in Deneb, and I confess, it's becoming a bit of an undertaking! To be specific, I'm looking to craft an hconcat that lines up 3-4 "columns" side by side. One column could be a bar, another a heatmap, and so on. Of course, the y-axis is shared among these "columns". But here's the twist, I need to mimic the functionality of clicking on a header to sort it - a feature that's strikingly akin to a Power BI table, a function our users are quite accustomed to and wouldn't want to let go. I've thoroughly combed through Vega's website and unearthed numerous cool features, but none seem to answer this exact question. Maybe it's right there and I'm overlooking it… Could anyone lend a hand or steer me in the right direction? Any help, suggestions, or guidance would be immensely appreciated. Why? - Native tables in Power BI are unfortunately still quite limited in customization, tooltips, etc. - Yet, users love tables, especially being able to create on-the-fly rankings by "sorting". - Keeping in mind what's achievable in Tableau, we believe that when used with discretion, Deneb could offer a super elegant and scalable alternative. PS: Maybe hconcat isn't the best approach, so I'm open to suggestions! I created this on vega editor as a first step:
Seeking help to recreate a table/card
Hi Community, I am trying to recreate a--very simple--scorecard for a client. This client creates a scorecard in Excel and I am attempting to recreate, verbatim, what they have created. I am struggling to find what I should use. I have tried a table, matrix and a kpi tile to no avail. Can anyone help guide me to what visual would be best to provide the below? Thank you!To get Total in between categories.
Hi, I have a table like this in Sheet 1- And from the sheet 1, I want to create Page 2 in Power BI which is like in Sheet 2 below- Difference is here the Total is populated through Sum formula. Values have been achieved through Vlookup- How I can do the same in Power BI by Exporting Sheet 1 and creating Sheet 2 from Sheet 1. Thanks, Amit KumarTable - One page report
Hello dear all, Is there someone who can help me to understand how to buid this visual bellow? The main challange here is to get data (KPI's names, department and etc) and just after, project in the colunms (monthly) the correspondent values (Being each colunm as a month) To make it a little bit harder, there are some conditional file formating rules (line by line) where each line is a KPI. Thank you in advance for any tip or idea. Best regards, João MorettiSlicer selection determine the column of the table
Hi, I would like to ask is it possible that Power BI able to develop the dashboard like the photo attached ? If can, may I get some ideas on how to develop ? The dashboard has 5 slices and each slicer is referred to the column of the table, the selection of slicer is the column name which able to select the column name and the table able to display the data of that column. The 1st slicer is referred to the 1st column of the table, 2nd slicer is referred to the 2nd column and so on. The 2nd column of the table is like the drill-down of the 1st column, 3rd column is like the drill-down of the 2nd column while column 4 and column 5 are the measure value. For example, when the user selects 'region' for the 1st slicer, 'distributor' for the 2nd slicer, 'salesman; for the 3rd slicer, 'year/month' for the 4th slicer and 'value in box' for the 5th slicer, the table will show all the regions for 1st column, all the distributors for the 2nd column and so on. Thank you
Table.columns.queryName property not updated after changing the aggregate function
I've created the following custom visual using a table Data View Mapping. If I added a column to my GroupingOrMeasure Data Role the table.columns.queryName property of this column takes the value of the first summarization option (which is sum): "Sum( Table.Column1 )". But if I change the aggregate function of this column to "Don't Summarize" (or any other), the queryName property doesn't update at all, is still "Sum( Table.Column1 )": Steps to reproduce this issue 1. Create the following table: 2. Create a custom visual with the following capability: Data Roles: "dataRoles": [ { "name": "columns", "kind": "GroupingOrMeasure", "displayName": "Columns" } ] Data View Mapping: "dataViewMappings": [ { "table": { "rows": { "select": [ { "for": { "in": "columns" } } ] } } } ] 3. Explore table.columns.queryName value with Show DataView button and see how this property is not updated after changing the aggregate function of Column1.
