HELP Create a Qlikviews "cyclic group" into PowerBI report

[markostalnacke]

We have a conversion project ongoing from Qlikview to PowerBI. Qlikview reports use "cyclic group" option in reports. How can this be taken into use in PowerBI. I saw some posts using  a slicer to select the dimension used for data viewing, but they didn't seem to work here.

We have a fact table with multible dimension tables (10+). Tables are joined via id-info. Results would be viewed mainly with table and bar chart combos. Optimal solution would have one slicer that would contain dimensions needed and fact data would be shown through that dimension. 

Any help would be appriciated, would not want to say that this cannot be done with PowerBI..

[Anonymous]

Hello, 

I'm having the same issue, did you find a solution for this problem ?

Best Regards,

[markostalnacke]

Hi, 
No, not yet. Pauls suggestion below doesn't do the trick, if I cannot change the complete "perspective" of matrix. (perspective=dimension)

[PaulDBrown]

@Anonymous 

I'm not too sure if this helps, but you can use calculation groups to change visuals dynamically:

https://www.havensconsulting.net/blog-and-media/conditionally-show/hide-matrix-columns 

[v-xulin-mstf]

Hi @markostalnacke,

As you described the method, please refer to the specific steps mentioned in the following post.

https://community.powerbi.com/t5/Desktop/Is-it-possible-to-dynamically-change-which-grouping-is-disp...

Hope it helps.

Best Regards,
Link

If this post helps then please consider Accept it as the solution to help the other members find it more quickly.

[markostalnacke]

I'm having difficulties trying that solution on my case. Let me try to describe it better, maybe you can advice more.

I have one fact table with multible dimension tables. Fact table has ID-info that is used to link to dimensions as usual. I would need to be able to "rotate" the dimension which is used to view the data. 

No just as a legend, but if possible also as a column in table just as in Qlikviews cyclic group.