Forum Discussion

Anonymous's avatar
Anonymous
Not applicable
5 years ago
Solved

Collapsible Tree Visual

Hi

Is there a way we can do collapsible tree to see dimensions? i have a columns like cpmany  level ,group and org which has like 2000 values in them so slicer may not be the best way to visualize that data also if we can filter the data based on the values in them that would  be gr8.I came across some d3jks power bi but not working .I dont have knowledge in JS i was just playing around.

 

https://stackoverflow.com/questions/28754273/d3-js-tree-expand-all-and-collapse-all

https://www.mssqltips.com/sqlservertip/5273/how-to-render-d3js-custom-charts-in-power-bi-desktop/

  • MFelix's avatar
    MFelix
    5 years ago

    Hi Anonymous ,

     

    I have place the sales but you can for example place the count of the company names then you can colour the data with white and that will not be seen in the tree visualization:

     

    Has you can see altough I'm doing a count of the company name it does not show any value in the tree.

5 Replies

  • Don't @kalishaa,

    Did the decomposition tree display protect is the same as it is present in the first-level link you provide.

    MFelix_1-1609843015696.png

  • Anonymous's avatar
    Anonymous
    Not applicable

    So i dont want to see by Sales i just the dimensions hierarchy in a tree. Is that possible with out a measure?

    • MFelix's avatar
      MFelix
      Super User

      Hi Anonymous ,

       

      I have place the sales but you can for example place the count of the company names then you can colour the data with white and that will not be seen in the tree visualization:

       

      Has you can see altough I'm doing a count of the company name it does not show any value in the tree.

      • Anonymous's avatar
        Anonymous
        Not applicable

        This looks cool , can you share teh PBI file?