Forum Discussion

Provodg's avatar
Provodg
New Member
4 years ago

Make Row Columns selectable for Power BI user

Hello everyone! It is necessary to implement the ability to select the grouping by days, weeks, months, quarters in the histogram. I tried to implement this through a list of parameters, created a table with a list: by days, by weeks, by months, by quarters. Created a measure with the code:

Parameter Value Time Slices = 
IF (
    HASONEVALUE ( 'Parameter list Time segments'[Parameter] ),
    SWITCH (
        VALUES ( 'Parameter list Time segments'[Parameter] ),
"For Day", [Spec day], 
"For Week", [Spec week],
"For Mounth", [Spec mounth],
                BLANK ()        
    )

I threw the "Slice" component on rendering so that you could select. But in the field of the visual component a Histogram with the "Row of Columns" grouping does not allow to place the measure "Parameter Value Time intervals". Maybe someone knows how to implement this?

3 Replies

  • Provodg If I understood if correctly, you want if Days is selected, the x-axis changed to day, if the week is selected x-axis changes to week? Is this correct understanding?

    • Provodg's avatar
      Provodg
      New Member
      I think yes. Only in the "X-axis" the grouping with the help of the "Slice" element has changed, by days, weeks, months. I am attaching a screenshot. There is an element "Chart and a bar chart with a grouping" in it "Y-axis", where the total of sales is displayed, and on the "X-axis" sales managers and their sales results are displayed. I need to make it possible to select a grouping model by day, week and month.
  • v-henryk-mstf's avatar
    v-henryk-mstf
    Community Support

    Hi Provodg ,

     

    Can the dynamic changes of the x-axis take effect? Refer to the following solutions.

    Solved: Dynamic change in X Axis - Microsoft Power BI Community


    If the problem is still not resolved, please provide detailed error information and let me know immediately. Looking forward to your reply.


    Best Regards,
    Henry


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