Forum Discussion
Grouping and Fixed value extraction
Hi
I am trying to migrate Tableau dashboard in to Power Bi. Please help me with below requests
1. Not able to get auto grouping in table - when I try to drag the items to table object they are not grouping automatically, I try with Matrix visualization as well but it is appearing as section not the grouping. Is there any settings I am missing here below is the screen shot for the same.
2. Adding to this I am trying to get maximum Ebill id for subscriber using Max and Allexcept to get maximum of ebill id for each subscriber (used LOD Fixed in tableau). The e xpression is valid but of no grouping it is returing same value for allcolumns. below is the screen shot for same.
3. Different date formatting in different visuals - I have many bar charts showing trends based on months but of different formats. One bar chart I display month axis as MMMYYYY(Jan 2019, Feb 2019) and in another chart I show as (January 2019, February 2019) and in another chart I show as (Jan 19, Feb 19) and in another (2019 Jan, 2019 Feb). I see these are very basic in Tableau where as I am finding difficulty in Power BI please help me with the workarounds.
Sincerely - Krishna
Hi Anonymous ,
On question 1, you are refering to a screenshot but it seems to be missing. What you are describing you are expecting should be default behaviour for power bi.
Test table with two category columns and a value columnStandard table visual with columns added, nothing else was done and it autogrouped as expected
On question 2: you are again missing the screenshots. However, by the looks of it you should wrap this in a calculate statement like this (Measure):
=CALCULATE( MAX ( Table[Ebill] ), ALLEXCEPT( Table, Table[Subscriber]))Applying this logic to the test set above and adding the measure to the table results in this:
On your third question, it is not possible to change the date format per visual if you want to use the same column. You set the format on a column level, not tied to a visual. However, you can copy the column and assign it a different format. Or, if using a dim_date table, you add the formats you require to the date table (preferred option). You can change the formatting by selecting the column in the Fields pane on the right of you screen, and then go to the Modelling tab on the top:
Let me know if this answers your questions and have a great new year! 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
5 Replies
Hi Anonymous ,
On question 1, you are refering to a screenshot but it seems to be missing. What you are describing you are expecting should be default behaviour for power bi.
Test table with two category columns and a value columnStandard table visual with columns added, nothing else was done and it autogrouped as expected
On question 2: you are again missing the screenshots. However, by the looks of it you should wrap this in a calculate statement like this (Measure):
=CALCULATE( MAX ( Table[Ebill] ), ALLEXCEPT( Table, Table[Subscriber]))Applying this logic to the test set above and adding the measure to the table results in this:
On your third question, it is not possible to change the date format per visual if you want to use the same column. You set the format on a column level, not tied to a visual. However, you can copy the column and assign it a different format. Or, if using a dim_date table, you add the formats you require to the date table (preferred option). You can change the formatting by selecting the column in the Fields pane on the right of you screen, and then go to the Modelling tab on the top:
Let me know if this answers your questions and have a great new year! 🙂
Kind regards
Djerro123
-------------------------------
If this answered your question, please mark it as the Solution. This also helps others to find what they are looking for.
Keep those thumbs up coming! 🙂
apologies, did not realize the attachment is not through. Can please guide me how to attach the screen captures I did not see the attachment option. I try to type in the values , requesting please consider first two columns for question 1 and third column for question 2.
Power Bi Separation Tableau Subscriber Bill ID Max Bill ID for Subscriber Subscriber Bill ID Max Bill ID for Subscriber 540646509 38988948399 38988948399 540646509 38988948399 38988948404 540646509 38988948400 38988948400 38988948400 38988948404 540646509 38988948401 38988948401 38988948401 38988948404 540646509 38988948402 38988948402 38988948402 38988948404 540646509 38988948403 38988948403 38988948403 38988948404 540646509 38988948404 38988948404 38988948404 38988948404 540646510 -2 -2 540646510 -2 -2 540646511 -2 -2 540646511 -2 -2 540646512 38988948405 38988948405 540646512 38988948405 38988948407 540646512 38988948406 38988948406 38988948406 38988948407 540646512 38988948407 38988948407 38988948407 38988948407 where both Subscriber and Ebill ID are defined as numbers.
Sicerely - Krishna
Hi Anonymous ,
We can create a measure as below to work on it.
Max Bill ID for Subscriber = VAR a = MAX ( 'Table'[Bill ID] ) VAR b = CALCULATE ( MAX ( 'Table'[Bill ID] ), ALLEXCEPT ( 'Table', 'Table'[Subscriber] ) ) RETURN IF ( a = b, b, BLANK () )
