Visualisation (Slicer and Button Slicer)
Hi everyone, I hope you all have a nice day. I want to ask (pictures attached), I gave an example of me using visualisation of "Button Slicer (Top)" and "Slicer (Bottom)" in the picture, I have a table where I have Reporting Date column then I make custom column for the quarters and months. The "Year" in the slicer is from Reporting Date hieararchy (Year), but the quarter and month in the slicer, they both are custom column that I made from the Reporting Date column (so they are not the hieararchy of "Reporting Date"). My questions (I don't mind if you answer with "Slicer" visualisation or "Button Slicer" visualisation): In Picture 1, If I select Q1 and it turns grey, how do the visualisation slicer for months turns black (for Jan, Feb, Mar) without me selecting the Quarter slicer? In Picture 2, If I select any month (for example: Aug) and it turns black, how do the visualisation slicer for quarter turns grey (Q2) without me selecting the Quarter slicer? In Picture 3, If I select Year "2025" and it turns black, how do the visualisation slicer for quarter and months also turns black without me selecting Quarter and Month slicer? Please kindly help me answer my questions. Thank you in advance. God bless. 😊🙏
acquireAADTokenService in PowerBI custom visual
Hello I'm trying to implement a custom visual that uses the authentication API following the documentaion. Though I'm using API 5.9.1, I don't have access to the service this.acquireAADTokenService(). It is not part of the IVisual interface. Any clue how to access this service ? Is there some sort of injection mecannism? Thanks for your help.PowerBi - Rerender data when change visuals
Hello every one, I create a custom visual and consult code from sampleBarChart in this link github. https://github.com/microsoft/PowerBI-visuals-sampleBarChart/tree/condFormat/Tutorial And I have a problem: when I switch to an existing visual, then switch back to my visual, the update function is not updated. Data is not rendered to the screen and there is no UI at all. I want to know that how can i make my custom visual can auto update and render data when i reopen it after open another visual like table or matrix vusual, tks all
Custom/Existing Visual regenerating on user selection
I am looking to either develop my own/find a visual that can dynamically regenerate/update based on a user selection. For context, the goal is simply to create a visual that lists a matrix of initial values (for example, a set of values that have a "-01" suffix) where a user can click on any of them that will then regenerate/update the visual with elements that have both the selected -01 suffix and the secondary -02 suffix, etc. for up to x amount of suffixes (basically recursive in a way). Considerations: Grid-like visual where it shows all the -01 values as a single boxed element Potentially attaching a url field (found in another column) that will hyperlink if they click the center of the box Having an 'expand' option within the element that will regenerate to the same grid-like visual, but using the initial selected value as a filter, and only showing rows where there is both -01 and the next -02 value This expanded version still maintains same behavior as if it was the -01 initial option, such as having the hyperlink option on direct click, or expand Methods originally considered but are not scalable: Using a series of cards (not sure if there is a url hyperlink attachment possible natively) Too many cards required and non adjustable without significant effort needed to incorporate Bookmarks (the amount of pages/bookmarks needed would need to be edited every single time when new entries are added) Had trouble figuring out how to properly get it to hide/show the next set of data properly or to filter correctly without external slicers on the page that also have to be interacted with Tree chart (although this kind of works, it is quite unintuitive and required an additional button for the hyperlink, as well as all prior elements in the tree remained on the page, cluttering the view even further Quick sketch of the principle I am looking to achieve below: From a 3x2 grid (adjustable/dynamic based on total values found and total size of the visual), user selects the + icon of the INTRO-01 box, which then leads to the next image, where its a subset of all the values under the INTRO-01 tag that are not the initial entry (for example, the act of clicking that element appends something that will now show anything that has a INTRO-01 tag AND the next set of tags). This can then keep incrementing as needed (depth and how many times this occurs would be manually built, up the amount of elements in the visual can dynamically change based on the data). Ideally this kind of visual is something that already exists somewhere, and if not, has capability within the developer API where I can build this kind of visual with its behavior myself. I have searched for this kind of behavior on the forums but most posts have not quite fulfilled the conditions I want or are using tables with values rather than something like this, which doesnt work as I had hoped. Some threads even mention this may not be possible, but those were relatively old so perhaps this kind of visual/behavior may have been added in since? Any tips or help would be appreciated.
Custom Shape MAP Fill color not filling
Hello all, from Portugal 😄 I've got a Custom MAP Shape, that should be filled, with a color from a column in a sharepoint. All the connections are working and the report is loading the Sharepoint list. The probllem is that the color declared on the sharepoint column is NOT filling the custom shape with the choosen color. Any help yould be appreciated! Tks in advance!
Multiple fields in custom visual
Hi, I have gone through many tutorials, and they all have on thing in common: they only work with one single input field for the visual. What I want to achieve is some kind of a targeted waterfall diagram, similar to the "Line with stacked column chart": One input field containing the planned (target) value for scaling the y axis and one input field containing the actual value for building the stair steps. Nice to have would also be a category to build a legend (i.e. color separation inside a step). It seems there is no way of creating a visual that accepts more than one data field, and table or matrix values don't seem to work anyway. Can anyone make a tutorial that shows how to work with multiple input fields? Thank you.Display True Measure in Data Label in Card with States by OKViz
Hi, I am looking for a way to display the calculated measure in the Data Label - Value section of the Card with States by OKViz visual rather than the predefined Average, Min, Max, First, Last, Sum and Dynamic. Is there any way to modify the Visual Template to show Measure Value rather than to calculate the average between the available dates? Current Template: {"name":"Custom","id":"auto-1643808119909","visualStyles":{"card":{"horAlignment":"left","alignment":"top","paddingTop":-5,"paddingLeft":4},"dataLabel":{"aggregate":"max","fill":{"solid":{"color":"#005825"}},"precision":0,"fontFamily":"'Comic Sans MS'"},"categoryLabel":{"type":"raw_measure","paddingTop":-10,"fill":{"solid":{"color":"#005825"}},"fontSize":10,"text":"{target}"},"trendLine":{"pointsWeight":2,"interpolation":"cardinal","fill":{"solid":{"color":"#005825"}},"markerFill":{"solid":{"color":"#005825"}},"curShow":false,"hiFill":{"solid":{"color":"#005825"}},"loShow":true,"loFill":{"solid":{"color":"#FF0000"}},"areaShow":true,"areaFill":{"solid":{"color":"#005825"}},"areaTransparency":10,"size":"half"}}} Thanks
